6.112 DBA_WAITERS
DBA_WAITERS
shows all the sessions that are waiting for a lock. In an Oracle RAC environment, this only applies if the waiter is on the same instance.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
The waiting session |
|
|
|
The container ID ( |
|
|
|
The holding session |
|
|
|
The container ID ( |
|
|
|
The lock type |
|
|
|
The mode held |
|
|
|
The mode requested |
|
|
|
Lock ID 1 |
|
|
|
Lock ID 2 |