VIEW: SYS.V_$LATCH_MISSES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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