V$LOCKED_OBJECT

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 


© Copyright SS64.com 1999-2014
Some rights reserved