Oracle9i Database Reference Release 1 (9.0.1) Part Number A90190-02 |
|
Static Data Dictionary Views, 200 of 521
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 |
|
|
|
See Also: 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-2001, Oracle Corporation. All Rights Reserved. |
|