Dynamic Performance (V$) Views, 70 of 179

V$LATCH

This view lists statistics for non-parent latches and summary statistics for parent latches. That is, the statistics for a parent latch include counts from each of its children.

Note: Columns SLEEP5, SLEEP6,... SLEEP11 are present for compatibility with previous versions of Oracle. No data are accumulated for these columns.

Column Datatype Description

ADDR

RAW(4)

Address of latch object

LATCH#

NUMBER

Latch number

LEVEL#

NUMBER

Latch level

NAME

VARCHAR2(64)

Latch name

GETS

NUMBER

Number of times obtained a wait

MISSES

NUMBER

Number of times obtained a wait but failed on the first try

SLEEPS

NUMBER

Number of times slept when wanted a wait

IMMEDIATE_GETS

NUMBER

Number of times obtained without a wait

IMMEDIATE_MISSES

NUMBER

Number of times failed to get without a wait

WAITERS_WOKEN

NUMBER

How many times a wait was awakened

WAITS_HOLDING _LATCH

NUMBER

Number of waits while holding a different latch

SPIN_GETS

NUMBER

Gets that missed first try but succeeded on spin

SLEEP1 ... SLEEP11

NUMBER

Waits that slept 1 time through 11 times, respectively

Column	Datatype	Description
`ADDR`	`RAW(4)`	Address of latch object
`LATCH#`	`NUMBER`	Latch number
`LEVEL#`	`NUMBER`	Latch level
`NAME`	`VARCHAR2(64)`	Latch name
`GETS`	`NUMBER`	Number of times obtained a wait
`MISSES`	`NUMBER`	Number of times obtained a wait but failed on the first try
`SLEEPS`	`NUMBER`	Number of times slept when wanted a wait
`IMMEDIATE_GETS`	`NUMBER`	Number of times obtained without a wait
`IMMEDIATE_MISSES`	`NUMBER`	Number of times failed to get without a wait
`WAITERS_WOKEN`	`NUMBER`	How many times a wait was awakened
`WAITS_HOLDING _LATCH`	`NUMBER`	Number of waits while holding a different latch
`SPIN_GETS`	`NUMBER`	Gets that missed first try but succeeded on spin
`SLEEP1 ... SLEEP11`	`NUMBER`	Waits that slept 1 time through 11 times, respectively