GV$LATCH definition in Oracle Database 11.2
GV$LATCH

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

home |  up