Get a specific session wait class record
get
/database/monitoring/session_wait_classes/{sid},{serial_number},{wait_class_number}
Returns the corresponding record from GV$SESSION_WAIT_CLASS. A client requires SQL Administrator role to invoke this service.
Request
Path Parameters
-
serial_number(required): number
Session serial number.
-
sid(required): number
Session identifier.
-
wait_class_number(required): number
Number of the wait class.
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
200 Response
Information on the specified session wait class.
Root Schema : MonitoringSessionWaitClassesItem
Type:
object
This object represents a record from GV$SESSION_WAIT_CLASS view. GV$SESSION_WAIT_CLASS displays the time spent in various wait event operations on a per-session basis. The list of attributes may vary depending on database version.
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
-
serial#: integer
Serial number.
-
sid: integer
Session identifier.
-
time_waited: integer
Amount of time spent in the wait class by the session.
-
total_waits: integer
Number of times waits of the class occurred for the session.
-
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.