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 nameCLASS
: A number representing one or moreSTATISTIC
classes ORed together; this can be:1
: User2
: Redo4
: Enqueue8
: Cache16
: OS32
: Real Application Clusters64
: SQL128
: Debug
STAT_ID
: The identifier of theSTATISTIC
See also
- The
V$MYSTAT
,V$SESSTAT
, andV$SYSSTAT
sections in this appendix
Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.