| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
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 |
|
 Copyright © 2002, 2003, Oracle Corporation All Rights Reserved. |
|
