Dynamic Performance (V$) Views, 159 of 179

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.

See Also:

"V$SESSTAT" and "V$SYSSTAT".

Appendix C, "Statistics Descriptions" for a description of each statistic.

Your operating system-specific Oracle documentation.

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`	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, Parallel Server 64, SQL 128, Debug