V$LATCH_CHILDREN

Data Dictionary View

Columns
   ___________________________
 
   ADDR
   LATCH#
   CHILD#
   LEVEL#
   NAME
   GETS
   MISSES
   SLEEPS
   IMMEDIATE_GETS
   IMMEDIATE_MISSES
   WAITERS_WOKEN
   WAITS_HOLDING_LATCH
   SPIN_GETS
   SLEEP1
   SLEEP2
   SLEEP3
   SLEEP4
   SLEEP5
   SLEEP6
   SLEEP7
   SLEEP8
   SLEEP9
   SLEEP10
   SLEEP11
   WAIT_TIME

Related:

V$CACHE
V$CLASS_PING 
V$DLM_LATCH 
V$ENQUEUE_LOCK 
V$EVENT_NAME 
V$LATCH 
V$LATCHHOLDER 
V$LATCHNAME 
V$LATCH_MISSES 
V$LATCH_PARENT 
V$LIBRARYCACHE 
V$LOCK 
V$LOCK_ELEMENT 
V$RESOURCE  
V$RESOURCE_LIMIT 
V$TRANSACTION_ENQUEUE 


© Copyright SS64.com 1999-2014
Some rights reserved