../E40402-16.epub /> ../E40402-16.mobi />

DBA_LOCK

DBA_LOCK lists all locks or latches held in the database, and all outstanding requests for a lock or latch.

Column Datatype NULL Description
SESSION_ID NUMBER   Session holding or acquiring the lock
LOCK_TYPE VARCHAR2(26)   Lock type

See Also: For a listing of lock types, see Appendix D, "Oracle Enqueue Names"

MODE HELD VARCHAR2(40)   Lock mode
MODE REQUESTED VARCHAR2(40)   Lock mode requested
LOCK_ID1 VARCHAR2(40)   Type-specific lock identifier, part 1
LOCK_ID2 VARCHAR2(40)   Type-specific lock identifier, part 2
LAST_CONVERT NUMBER   The last convert
BLOCKING_OTHERS VARCHAR2(40)   Whether the lock is currently blocking others