Get all locks that sessions are waiting on

get

/database/monitoring/session_locks/waiting/

Using DBA_LOCKS and DBA_WAITERS views, this service returns a list of DBA_LOCKS records for sessions that are waiting on locks held by other sessions. In an Oracle RAC environment, this only applies if the waiter is on the same instance. A client requires SQL Administrator role to invoke this service.

Request

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 locks in the database that sessions are waiting on.
Body ()
Root Schema : MonitoringSessionLocksWaiting
Type: object
This collection represents database locks held by sessions that are waiting on other sessions. The list of attributes may vary depending on database version.
Show Source
Nested Schema : items
Type: array
Show Source
  • MonitoringSessionLocksItem
    This object is represents a record on DBA_LOCK view. DBA_LOCK lists all locks or latches held in the database, and all outstanding requests for a lock or latch. The list of attributes may vary depending on database version.
Nested Schema : MonitoringSessionLocksItem
Type: object
This object is represents a record on DBA_LOCK view. DBA_LOCK lists all locks or latches held in the database, and all outstanding requests for a lock or latch. The list of attributes may vary depending on database version.
Show Source
Nested Schema : LinkRelation
Type: object
Show Source
Back to Top