9.104 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 |
|
|
Total number of waits from this wait class |
|
|
Total amount of time spent in waits from this wait class (in hundredths of a second) |
|
|
Total number of waits for this wait class, from foreground sessions |
|
|
Total amount of time spent in waits from this wait class, from foreground sessions (in hundredths of a second) |
|
|
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.