Databases Reference
In-Depth Information
Fields
The most relevant view fields are as follows:
F
STATISTIC#
: The statistic number (may change across different database versions)
F
NAME
: The statistic name
F
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
F
STAT_ID
: The identifier of the
STATISTIC
See also
F
The
V$MYSTAT
,
V$SESSTAT
, and
V$SYSSTAT
sections in this appendix
V$SYSSTAT
This view displays system statistics.
Fields
The most relevant view fields are as follows:
F
STATISTIC#
: The statistic number
F
NAME
: The statistic name
F
CLASS
: A number representing one or more statistic classes ORed together;
the values are same as those mentioned in the previous section
F
VALUE
: The statistic value
F
STAT_ID
: The identifier of the statistic
