V_$STATNAME

컬럼명	설명
STATISTIC#
NAME
CLASS	classid 분류 2진수 해석 1 User "00000001"    2 Redo "00000010"    4 Enque "00000100"    8 Cache "00001000"    16 OS "00010000"    32 RAC "00100000"    40    "00101000" RAC+Cache 64 SQL "01000000"    72    "01001000" SQL+Cache 128 Debug "10000000"
STAT_ID

※ 참고 : select distinct class from v$statname order by class;

V$STATNAME

This view displays decoded statistic names for the statistics shown in the V$SESSTAT and V$SYSSTAT tables.

On some platforms, the NAME and CLASS columns contain additional operating system-specific statistics.

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 classes. The following class numbers are additive: 1 - User 2 - Redo 4 - Enqueue 8 - Cache 16 - OS 32 - Real Application Clusters 64 - SQL 128 - Debug
STAT_ID	NUMBER	Identifier of the statistic

   

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