DBA_LOCK_INTERNAL displays a row for each lock or latch that is being held, and one row for each outstanding request for a lock or latch.

Column Datatype NULL Description
SESSION_ID NUMBER   Session holding or acquiring the lock
LOCK_TYPE VARCHAR2(56)   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(1130)   Type-specific lock identifier, part 1
LOCK_ID2 VARCHAR2(40)   Type-specific lock identifier, part 2