V$LATCH_PARENT

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

Related Commands: