Home Oracle Commands v$ Performance views
Oracle Data Dictionary

V$DLM_ALL_LOCKS

Data Dictionary View

Columns
   ___________________________
 
   LOCKP
   GRANT_LEVEL
   REQUEST_LEVEL
   RESOURCE_NAME1
   RESOURCE_NAME2
   PID
   TRANSACTION_ID0
   TRANSACTION_ID1
   GROUP_ID
   OPEN_OPT_DEADLOCK
   OPEN_OPT_PERSISTENT
   OPEN_OPT_PROCESS_OWNED
   OPEN_OPT_NO_XID
   CONVERT_OPT_GETVALUE
   CONVERT_OPT_PUTVALUE
   CONVERT_OPT_NOVALUE
   CONVERT_OPT_DUBVALUE
   CONVERT_OPT_NOQUEUE
   CONVERT_OPT_EXPRESS
   CONVERT_OPT_NODEADLOCKWAIT
   CONVERT_OPT_NODEADLOCKBLOCK
   WHICH_QUEUE
   LOCKSTATE
   AST_EVENT0
   OWNER_NODE
   BLOCKED
   BLOCKER

Related:

V$BUFFER_POOL 
V$CACHE
V$CLASS_PING 
V$DLM_CONVERT_LOCAL 
V$DLM_CONVERT_REMOTE 
V$DLM_LATCH 
V$DLM_LOCKS 
V$DLM_MISC 
V$DLM_RESS 
V$DLM_TRAFFIC_CONTROLLER 
V$ENQUEUE_LOCK 
V$EVENT_NAME 
V$LATCH 
V$LATCHHOLDER 
V$LATCHNAME 
V$LATCH_CHILDREN 
V$LATCH_MISSES 
V$LATCH_PARENT 
V$LIBRARYCACHE 
V$LOCK 
V$_LOCK
V$LOCKED_OBJECT 
V$LOCKS_WITH_COLLISIONS 
V$LOCK_ACTIVITY 
V$LOCK_ELEMENT 
V$RESOURCE  
V$RESOURCE_LIMIT 
V$TRANSACTION_ENQUEUE 



Simon Sheppard
SS64.com