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