GV$LATCH definition in Oracle 8i / www.oracledba.ru
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(64)
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
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
from
x$ksllt
group by kslltnum) la
where
la.latch# = d.indx