4.141 DBA_BLOCKERS
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.
In an Oracle RAC environment, this only applies if the blocker is on the same instance.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Session holding a lock |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|