ADDR 

RAW(4) 

Address of latch object 

LATCH# 

NUMBER 

Latch number for a parent latch 

CHILD# 

NUMBER 

Child number of a parent latch shown in LATCH# 

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 time 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 

SLEEPn 

NUMBER 

Waits that slept n times