V$LATCH_CHILDREN

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

Related Views:

V$BUFFER_POOL 
V$CACHE
V$CACHE_LOCK
V$CLASS_PING 
V$DLM_CONVERT_LOCAL 
V$DLM_CONVERT_REMOTE 
V$DLM_LATCH 
V$DLM_MISC 
V$ENQUEUE_LOCK 
V$EVENT_NAME 
V$FALSE_PING
V$LATCH 
V$LATCHHOLDER 
V$LATCHNAME 
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$PING
V$RESOURCE  
V$RESOURCE_LIMIT 
V$TRANSACTION_ENQUEUE