Tuesday, September 23, 2008

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.

Column

Datatype

NULL

Description

HOLDING_SESSION

NUMBER

Session holding a lock

Oracle data dictionary views

Oracle dynamic performance views

No comments:

Post a Comment