V$STATNAME

This view is used to decode a statistic identifier to its description.

Fields

The most relevant view fields are as follows:

• STATISTIC#: The statistic number (may change across different database versions)

• NAME: The statistic name

• CLASS: A number representing one or more STATISTIC classes ORed together; this can be:

  • 1: User

  • 2: Redo

  • 4: Enqueue

  • 8: Cache

  • 16: OS

  • 32: Real Application Clusters

  • 64: SQL

  • 128: Debug

• STAT_ID: The identifier of the STATISTIC

See also

• The V$MYSTAT, V$SESSTAT, and V$SYSSTAT sections in this appendix