Data Dictionary View
Columns ___________________________ ORACLE_USERNAME OS_USER_NAME PROCESS LOCKED_MODE XIDUSN XIDSLOT XIDSQN OBJECT_ID SESSION_ID
Who is locking what:
select
oracle_username
os_user_name,
locked_mode,
object_name,
object_type
from
v$locked_object a,dba_objects b
where
a.object_id = b.object_id
Related:
V$ENQUEUE_LOCK V$LATCH V$LOCK V$_LOCK V$LOCKS_WITH_COLLISIONS V$LOCK_ACTIVITY V$LOCK_ELEMENT V$RESOURCE V$RESOURCE_LIMIT V$TRANSACTION_ENQUEUE