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 |
|---|---|---|---|
HOLDING_SESSION |
NUMBER |
Session holding a lock |