V$MYSTAT

Oracle 11gR1

V$MYSTAT contains statistics on the current session.

Column	Datatype	Description
SID	NUMBER	ID of the current session
STATISTIC#	NUMBER	Number of the statistic
VALUE	NUMBER	Value of the statistic

Note:

1.

select * from V$mystat where statistic#<9;

SID	STATISTIC#	VALUE
1744	0	1
1744	1	1
1744	2	2010
1744	3	10
1744	4	0
1744	5	0
1744	6	248
1744	7	26263
1744	8	185

Oracle dynamic performance views