GV$LATCH_PARENT

select
t.inst_id,               -- INST_ID NUMBER
t.addr,                  -- ADDR RAW(4)
t.kslltnum,              -- LATCH# NUMBER
n.kslldlvl,              -- LEVEL# NUMBER
n.kslldnam,              -- NAME VARCHAR2(50)
n.kslldhsh,              -- 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$ksllt t,
x$kslld n 
where
t.kslltcnm = 0 and t.kslltnum = n.indx
home |  up  |  mailbox