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