V$SYSSTAT
displays system statistics. To find the name of the statistic associated with each statistic number (STATISTIC#
), query the V$STATNAME
view.
Column | Datatype | Description |
---|---|---|
|
|
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. |
|
|
Statistic name. You can get a complete listing of statistic names by querying the |
|
|
A number representing one or more statistics class. The following class numbers are additive:
|
|
|
Statistic value |
|
|
Identifier of the statistic |
|
|
The ID of the container to which the data pertains. Possible values include:
|
Note:
This view returns instance-wide data and a value of 0
in the CON_ID
column when queried from the root of a CDB.
See Also: