Dynamic Performance (V$) Views, 74 of 179

V$LATCH_MISSES

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

Column Datatype Description

PARENT_NAME

VARCHAR2

Latch name of a parent latch

WHERE

VARCHAR2

Location that attempted to acquire the latch

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

???

Column	Datatype	Description
`PARENT_NAME`	`VARCHAR2`	Latch name of a parent latch
`WHERE`	`VARCHAR2`	Location that attempted to acquire the latch
`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`	???