Get all wait class metrics
get
/database/monitoring/wait_class_metrics
Returns all records from GV$WAITCLASSMETRIC for all GV$SYSTEM_WAIT_CLASS records except 'Idle' wait class. A client requires SQL Administrator role to invoke this service.
Request
There are no request parameters for this operation.
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
200 Response
Wait class metrics records.
Root Schema : MonitoringWaitClassMetricsItem
Type:
object
This object combines data from GV$WAITCLASSMETRIC and GV$SYSTEM_WAIT_CLASS views to represent metric values of wait classes for the most recent 60-second interval.
Show Source
Nested Schema : items
Type:
Show Source
object
-
average_waiter_count: integer
Average waiter count.
-
begin_time: string
Begin time of the interval.
-
con_id: integer
The ID of the container to which the data pertains.
-
dbtime_in_wait: integer
Percent of database time spent in the wait.
-
end_time: string
End time of the interval.
-
intsize_csec: integer
Interval size (in hundredths of a second).
-
time_waited: integer
Amount of time (in hundredths of a second) spent in the wait by all sessions in the instance.
-
time_waited_fg: integer
Amount of time (in hundredths of a second) spent in waits from this wait class in foreground sessions.
-
total_waits: integer
Number of times waits of the class occurred.
-
total_waits_fg: integer
Number of times waits from this wait class occurred in foreground sessions.
-
wait_class: string
Name of the wait class.
-
wait_class#: integer
Number of the wait class.
-
wait_class_id: integer
Identifier of the wait class.
-
wait_count: integer
Number of times waited.
-
wait_count_fg: integer
Number of times foreground processes waited.