Get all locks that are blocking other sessions
get
/database/monitoring/session_locks/holding/
Using DBA_LOCKS and DBA_BLOCKERS views, this service returns a list of DBA_LOCKS records 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
Query Parameters
-
limit(optional):
The maximum number of records to return.
-
q(optional):
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.
Response
200 Response
All locks that are blocking other sessions.