Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

Part Number B10755-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

Go to previous page
Go to next page
View PDF


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 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 from this loc
LONGHOLD_COUNT NUMBER Number of times someone held a latch for the entire duration of someone else's sleep
LOCATION VARCHAR2(64) Location that attempted to acquire the latch