V$LATCH_CHILDREN

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

Related Commands: