Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


V$LATCH_MISSES displays statistics about missed attempts to acquire a latch.

Column Datatype Description
PARENT_NAME VARCHAR2(64) Latch name of a parent latch
WHERE VARCHAR2(80) This column is obsolete and maintained for backward compatibility. 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 Number of times a waiter slept
LONGHOLD_COUNT NUMBER Number of times someone held a latch for the entire duration of someone else's sleep
LOCATION VARCHAR2(80) Location that attempted to acquire the latch