Get time totals for all registered wait classes
get
/database/monitoring/wait_class_totals
Returns all the records from GV$SYSTEM_WAIT_CLASS, 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
Summary information on the wait class time totals.
Root Schema : MonitoringWaitClassTotalsItem
Type:
object
Time totals for each registered wait class
Show Source
-
con_id: integer
The ID of the container to which the data pertains.
-
inst_id: integer
Oracle Real Application Clusters instance number for which this data relates to. In a non-RAC database this number will be 1.
-
links: array
links
-
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.