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 Appendix D, "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 |
DBA_DML_LOCKS
lists all DML locks held in the database and all outstanding requests for a DML lock.
Column | Datatype | NULL | Description |
---|---|---|---|
| | Session holding or acquiring the lock | |
| | | Owner of the lock |
| | | Name of the lock |
| | The type of lock held. The values are:
| |
| | Lock request type. The values are:
| |
| | The last convert | |
| | Blocking others |
DBA_DDL_LOCKS
lists all DDL locks held in the database and all outstanding requests for a DDL lock.
Column | Datatype | NULL | Description |
---|---|---|---|
| | Session identifier | |
| | Owner of the lock | |
| | Name of the lock | |
| | Lock type:
| |
| | Lock mode:
| |
| | Lock request type:
|
DBA_WAITERS
shows all the sessions that are waiting for a lock.
Column | Datatype | NULL | Description |
---|---|---|---|
| | The waiting session | |
| | The holding session | |
| | The lock type | |
| | The mode held | |
| | The mode requested | |
| | Lock ID 1 | |
| | Lock ID 2 |
DBA_BLOCKERS
displays a session if it is not waiting for a locked object but is holding a lock on an object for which another session is waiting.
Column | Datatype | NULL | Description |
---|---|---|---|
| | Session holding a lock |
Reference