| Oracle9i Database Reference Release 2 (9.2) Part Number A96536-02 |
|
|
View PDF |
| Oracle9i Database Reference Release 2 (9.2) Part Number A96536-02 |
|
|
View PDF |
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 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, 2002 Oracle Corporation. All Rights Reserved. |
|
