Oracle® Database Reference 11g Release 2 (11.2) Part Number E10820-02 |
|
|
View PDF |
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 a RAC environment, this only applies if the blocker is on the same instance.
Column | Datatype | NULL | Description |
---|---|---|---|
HOLDING_SESSION |
NUMBER |
Session holding a lock |