V$LATCH_MISSES

This view contains statistics about missed attempts to acquire a latch.

Column	Datatype	Description
PARENT_NAME	VARCHAR2(50)	Latch name of a parent latch
WHERE	VARCHAR2(64)	This column is obsolete and maintained only for compatibility reasons. The value of this column is always equal to the value in LOCATION.
NWFAIL_COUNT	NUMBER	Number of times that no-wait acquisition of the latch failed
SLEEP_COUNT	NUMBER	Number of times that acquisition attempts caused sleeps
WTR_SLP_COUNT	NUMBER
LONGHOLD_COUNT	NUMBER
LOCATION	VARCHAR2(64)	Location that attempted to acquire the latch