VIEW: SYS.GV_$LATCH_MISSES

Source

View Text - Preformatted

select "INST_ID","PARENT_NAME","WHERE","NWFAIL_COUNT","SLEEP_COUNT","WTR_SLP_COUNT","LONGHOLD_COUNT","LOCATION","CON_ID" from gv$latch_misses

View Text - HTML Formatted

SELECT "INST_ID"
, "PARENT_NAME"
, "WHERE"
, "NWFAIL_COUNT"
, "SLEEP_COUNT"
, "WTR_SLP_COUNT"
, "LONGHOLD_COUNT"
, "LOCATION"
, "CON_ID"
FROM GV$LATCH_MISSES