Databases Reference
In-Depth Information
V$LATCH
This view displays aggregate latch statistics.
Fields
The most relevant view fields are as follows:
F
LATCH#
: The latch number
F
NAME
: The latch name
F
GETS
: The number of times the latch is requested in the willing-to-wait mode
F
MISSES
: The number of times the latch is requested in willing-to-wait mode and
the requestor had to wait
F
SLEEPS
: The number of times a willing-to-wait latch request resulted in a session
sleeping
F
SPIN_GETS
: The number of times a willing-to-wait latch request was satisfied only
after a spin
F
WAIT_TIME
: The elapsed time spent waiting for the latch in microseconds
F
IMMEDIATE_GETS
: The number of times the latch is requested in no-wait mode
F
IMMEDIATE_MISSES
: The number of times a no-wait latch request was unsatisfied
See also
F
The
V$LATCH_CHILDREN
recipe in this appendix
V$LATCH_CHILDREN
This view displays statistics about child latches.
Fields
The most relevant view fields are:
F
CHILD#
: The child latch number
F
LATCH#
: The parent latch number
F
NAME
: The latch name
F
GETS
: The number of times the latch is requested in willing-to-wait mode