Get a session lock that is blocking other sessions

get

/database/monitoring/session_locks/holding/{session_id},{lock_id1},{lock_id2}

Using DBA_LOCKS and DBA_BLOCKERS views, this service returns a specific DBA_LOCKS record where the session is not waiting for a locked object but is holding a lock on an object for which another session is waiting. In an Oracle RAC environment, this only applies if the blocker is on the same instance. A client requires SQL Administrator role to invoke this service.

Request

Supported Media Types
Path Parameters
Back to Top

Response

Supported Media Types

200 Response

Information on a specific session lock.
Body ()
Root 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