GV$LATCH
select d.inst_id, -- INST_ID NUMBER d.kslldadr, -- ADDR RAW(4) la.latch#, -- LATCH# NUMBER d.kslldlvl, -- LEVEL# NUMBER d.kslldnam, -- NAME VARCHAR2(50) d.kslldhsh, -- HASH NUMBER la.gets, -- GETS NUMBER la.misses, -- MISSES NUMBER la.sleeps, -- SLEEPS NUMBER la.immediate_gets, -- IMMEDIATE_GETS NUMBER la.immediate_misses, -- IMMEDIATE_MISSES NUMBER la.waiters_woken, -- WAITERS_WOKEN NUMBER la.waits_holding_latch, -- WAITS_HOLDING_LATCH NUMBER la.spin_gets, -- SPIN_GETS NUMBER la.sleep1, -- SLEEP1 NUMBER la.sleep2, -- SLEEP2 NUMBER la.sleep3, -- SLEEP3 NUMBER la.sleep4, -- SLEEP4 NUMBER la.sleep5, -- SLEEP5 NUMBER la.sleep6, -- SLEEP6 NUMBER la.sleep7, -- SLEEP7 NUMBER la.sleep8, -- SLEEP8 NUMBER la.sleep9, -- SLEEP9 NUMBER la.sleep10, -- SLEEP10 NUMBER la.sleep11, -- SLEEP11 NUMBER la.wait_time -- WAIT_TIME NUMBER from x$kslld d, ( select kslltnum latch#, sum (kslltwgt) gets, sum (kslltwff) misses, sum (kslltwsl) sleeps, sum (kslltngt) immediate_gets, sum (kslltnfa) immediate_misses, sum (kslltwkc) waiters_woken, sum (kslltwth) waits_holding_latch, sum (ksllthst0) spin_gets, sum (ksllthst1) sleep1, sum (ksllthst2) sleep2, sum (ksllthst3) sleep3, sum (ksllthst4) sleep4, sum (ksllthst5) sleep5, sum (ksllthst6) sleep6, sum (ksllthst7) sleep7, sum (ksllthst8) sleep8, sum (ksllthst9) sleep9, sum (ksllthst10) sleep10, sum (ksllthst11) sleep11, sum (kslltwtt) wait_time from x$ksllt group by kslltnum) la where la.latch# = d.indx

home |  up  |  mailbox