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 |