9.103 V$SYSTEM_WAIT_CLASS
V$SYSTEM_WAIT_CLASS
displays the instance-wide time totals for each registered wait class.
Column | Datatype | Description |
---|---|---|
|
|
Identifier of the wait class |
|
|
Number of the wait class |
|
|
Name of the wait class |
|
|
Number of times waits of the class occurred |
|
|
Amount of time (in hundredths of a second) spent in the wait by all sessions in the instance |
|
|
Number of times waits from this wait class occurred in foreground sessions |
|
|
Amount of time (in hundredths of a second) spent in waits from this wait class in foreground sessions |
|
|
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.