Oracle8i Reference
Release 2 (8.1.6)

A76961-01

Library

Product

Contents

Index

Prev Up Next

Dynamic Performance (V$) Views, 73 of 179


V$LATCH_CHILDREN

This view contains statistics about child latches. This view includes all columns of V$LATCH plus the CHILD# column. Note that child latches have the same parent if their LATCH# columns match each other.

See Also:

"V$LATCH"

Column  Datatype  Description 

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 


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index