GV$LATCH_MISSES

select
t1.inst_id,              -- INST_ID NUMBER
t1.ksllasnam,            -- PARENT_NAME VARCHAR2(50)
t2.ksllwnam,             -- WHERE VARCHAR2(64)
t1.kslnowtf,             -- NWFAIL_COUNT NUMBER
t1.kslsleep,             -- SLEEP_COUNT NUMBER
t1.kslwscwsl,            -- WTR_SLP_COUNT NUMBER
t1.kslwsclthg,           -- LONGHOLD_COUNT NUMBER
t2.ksllwnam              -- LOCATION VARCHAR2(64)
from
x$ksllw t2,
x$kslwsc t1 
where
t2.indx = t1.indx
home |  up  |  mailbox