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