GV$LATCH_MISSESselect 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