GV$LATCH_PARENT definition in Oracle Database 11.2
GV$LATCH_PARENT

select
  t.inst_id,                               -- INST_ID NUMBER
  t.kslltaddr,                             -- ADDR RAW(8)
  t.kslltnum,                              -- LATCH# NUMBER
  t.kslltlvl,                              -- LEVEL# NUMBER
  t.kslltnam,                              -- NAME VARCHAR2(64)
  t.ksllthsh,                              -- HASH NUMBER
  t.kslltwgt,                              -- GETS NUMBER
  t.kslltwff,                              -- MISSES NUMBER
  t.kslltwsl,                              -- SLEEPS NUMBER
  t.kslltngt,                              -- IMMEDIATE_GETS NUMBER
  t.kslltnfa,                              -- IMMEDIATE_MISSES NUMBER
  t.kslltwkc,                              -- WAITERS_WOKEN NUMBER
  t.kslltwth,                              -- WAITS_HOLDING_LATCH NUMBER
  t.ksllthst0,                             -- SPIN_GETS NUMBER
  t.ksllthst1,                             -- SLEEP1 NUMBER
  t.ksllthst2,                             -- SLEEP2 NUMBER
  t.ksllthst3,                             -- SLEEP3 NUMBER
  t.ksllthst4,                             -- SLEEP4 NUMBER
  t.ksllthst5,                             -- SLEEP5 NUMBER
  t.ksllthst6,                             -- SLEEP6 NUMBER
  t.ksllthst7,                             -- SLEEP7 NUMBER
  t.ksllthst8,                             -- SLEEP8 NUMBER
  t.ksllthst9,                             -- SLEEP9 NUMBER
  t.ksllthst10,                            -- SLEEP10 NUMBER
  t.ksllthst11,                            -- SLEEP11 NUMBER
  t.kslltwtt                               -- WAIT_TIME NUMBER
from
  x$kslltr_parent t

home |  up