Oracle8i Reference Release 2 (8.1.6) Part Number A76961-01 |
|
Static Data Dictionary Views, 172 of 452
DBA_LOCKS
lists all locks or latches held in the database, and all outstanding requests for a lock or latch.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Session holding or acquiring the lock |
|
|
|
Lock type. For a listing of lock types, see Appendix B, "Oracle Enqueue Names". |
|
|
|
Lock mode |
|
|
|
Lock mode requested |
|
|
|
Type-specific lock identifier, part 1 |
|
|
|
Type-specific lock identifier, part 2 |
|
|
|
The last convert |
|
|
|
Whether the lock is currently blocking others |
|
![]() Copyright © 1996-2000, Oracle Corporation. All Rights Reserved. |
|