Identifying Blocking Transactions in Oracle
V$LOCK and data dictionary tables such as DBA_OBJECTS to retrieve currently locked objects.
RJB is holding a
EMPLOYEES table, and HR is waiting for the lock to be released. It also liststhe session ID and the workstation ID of each user.