Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 |
|
|
PDF · Mobi · ePub |
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 |