DBA_WAITERS

DBA_WAITERS shows all the sessions that are waiting for a lock. In an Oracle RAC environment, this only applies if the waiter is on the same instance.

Column Datatype NULL Description
WAITING_SESSION NUMBER   The waiting session
HOLDING_SESSION NUMBER   The holding session
LOCK_TYPE VARCHAR2(26)   The lock type
MODE_HELD VARCHAR2(40)   The mode held
MODE_REQUESTED VARCHAR2(40)   The mode requested
LOCK_ID1 VARCHAR2(40)   Lock ID 1
LOCK_ID2 VARCHAR2(40)   Lock ID 2