V$SYSSTAT

Oracle 11gR1

V$SYSSTAT displays system statistics. To find the name of the statistic associated with each statistic number (STATISTIC#), query the V$STATNAME view.

Column	Datatype	Description
STATISTIC#	NUMBER	Statistic number Note: Statistics numbers are not guaranteed to remain constant from one release to another. Therefore, you should rely on the statistics name rather than its number in your applications.
NAME	VARCHAR2(64)	Statistic name. You can get a complete listing of statistic names by querying the V$STATNAME view.
CLASS	NUMBER	A number representing one or more statistics class. The following class numbers are additive: · 1 - User · 2 - Redo · 4 - Enqueue · 8 - Cache · 16 - OS · 32 - Real Application Clusters · 64 - SQL · 128 - Debug
VALUE	NUMBER	Statistic value
STAT_ID	NUMBER	Identifier of the statistic

Note:

1.

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

STATISTIC#	NAME	CLASS	VALUE	STAT_ID
0	logons cumulative	1	494622	2666645286
1	logons current	1	1055	3080465522
2	opened cursors cumulative	1	1033393653	85052502
3	opened cursors current	1	34877	2301954928
4	user commits	1	30813864	582481098
5	user rollbacks	1	331503	3671147913
6	user calls	1	1678495820	2882015696
7	recursive calls	1	7041229463	2656001462
8	recursive cpu usage	1	200205944	4009879262

Oracle dynamic performance views