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.
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(optional):
integer
The ID of the container to which the data pertains.
-
inst_id(optional):
integer
Oracle Real Application Clusters instance number for which this data relates to. In a non-RAC database this number will be 1.
-
links(optional):
array links
-
time_waited(optional):
integer
Amount of time (in hundredths of a second) spent in the wait by all sessions in the instance.
-
time_waited_fg(optional):
integer
Amount of time (in hundredths of a second) spent in waits from this wait class in foreground sessions.
-
total_waits(optional):
integer
Number of times waits of the class occurred.
-
total_waits_fg(optional):
integer
Number of times waits from this wait class occurred in foreground sessions.
-
wait_class(optional):
string
Name of the wait class.
-
wait_class#(optional):
integer
Number of the wait class.
-
wait_class_id(optional):
integer
Identifier of the wait class.