Skip Headers
This view contains statistics about missed attempts to acquire a latch.
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.
LOCATION
NWFAIL_COUNT
NUMBER
Number of times that no-wait acquisition of the latch failed
SLEEP_COUNT
Number of times that acquisition attempts caused sleeps
WTR_SLP_COUNT
LONGHOLD_COUNT
Location that attempted to acquire the latch