5.145 DBA_LOCK
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 |
|
|
|
Lock type See Also: For a listing of lock types, see 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 |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|