Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

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