| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03  | 
  | 
  | 
PDF · Mobi · ePub | 
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 |