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