V_$SYSSTAT

V$SYSSTAT

This view lists 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
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

   

원본 위치 <http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_2150.htm#sthref2794>

   

컬럼명	설명
STATISTIC#
NAME
CLASS
VALUE
STAT_ID

관련 질의 : @sysStat

col name form a30;

select * from (select * from v$sysstat where class=&CLASS

order by value desc) where rownum<=&&TOP_NUM