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:
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 lock that a session is waiting on.