Get a specific lock that a session is waiting on
get
/database/monitoring/session_locks/waiting/{session_id},{lock_id1},{lock_id2}
Using DBA_LOCKS and DBA_WAITERS views, this service returns the corresponding DBA_LOCKS records for session that is 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
Path Parameters
-
lock_id1: string
Type-specific lock identifier, part 1.
-
lock_id2: string
Type-specific lock identifier, part 2.
-
session_id: number
Session identifier.
Response
Supported Media Types
- application/json
200 Response
Information on a specific lock that a session is waiting on.
Root Schema : MonitoringSessionLocksItem
Type:
objectThis 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
-
blocking_others(optional):
string
Whether the lock is currently blocking others.
-
con_id(optional):
integer
The ID of the container to which the data pertains.
-
last_convert(optional):
integer
The last convert.
-
links(optional):
array links
-
lock_id1(optional):
string
Type-specific lock identifier, part 1.
-
lock_id2(optional):
string
Type-specific lock identifier, part 2.
-
lock_type(optional):
string
Lock type.
-
mode_held(optional):
string
Lock mode.
-
mode_requested(optional):
string
Lock mode requested.
-
session_id(optional):
integer
Session holding or acquiring the lock.