Get all session waits

get

/database/monitoring/session_waits/

Returns all records from GV$SESSION_WAIT.

Request

Supported Media Types
Query Parameters
  • The maximum number of records to return.
  • Filtering is the process of limiting a collection resource by using a per-request dynamic filter definition across multiple page resources, where each page contains a subset of items found in the complete collection. Filtering enables efficient traversal of large collections.
Back to Top

Response

Supported Media Types

200 Response

All session wait records from GV$SESSION_WAIT. A client requires SQL Administrator role to invoke this service.
Body ()
Root Schema : MonitoringSessionWaits
Type: object
Show Source
Nested Schema : items
Type: array
Show Source
  • MonitoringSessionWaitsItem
    This object represents a record from GV$SESSION_WAIT view. GV$SESSION_WAIT displays the current or last wait for each session. The list of attributes may vary depending on database version.
Nested Schema : MonitoringSessionWaitsItem
Type: object
This object represents a record from GV$SESSION_WAIT view. GV$SESSION_WAIT displays the current or last wait for each session. The list of attributes may vary depending on database version.
Show Source
Nested Schema : LinkRelation
Type: object
Show Source
Back to Top