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
Path Parameters
-
lock_id1:
Type-specific lock identifier, part 1.
-
lock_id2:
Type-specific lock identifier, part 2.
-
session_id:
Session identifier.
Response
200 Response
Information on a specific session lock.