V$WAITCLASSMETRIC
displays metric values of wait classes for the most recent 60-second interval. A history of the last one hour will be kept in the system.
Column | Datatype | Description |
---|---|---|
|
|
Begin time of the interval |
|
|
End time of the interval |
|
|
Interval size (in hundredths of a second) |
|
|
Number of the class of the wait event |
|
|
Identifier of the class of the wait event |
|
|
Average waiter count |
|
|
Percent of database time spent in the wait |
|
|
Time waited during the interval (in hundredths of a second) |
|
|
Number of times waited |
|
|
Amount of time (in hundredths of a second) spent in waits from this wait class in foreground sessions |
|
|
Number of times foreground processes waited |
|
|
The ID of the container to which the data pertains. Possible values include:
|