Databases Reference
In-Depth Information
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
section in this appendix
V$LIBRARYCACHE
Displays statistics on library cache activity.
Fields
The most relevant view fields are:
F
NAMESPACE
: The library cache namespace
F
GETS
: The number of times a lock was requested for objects in the namespace
F
GETHITRATIO
: The number of times the object's handle was found in memory
F
PINS
: The number of times a
PIN
was requested for objects in the namespace
F
PINHITRATIO
: The number of times the object's metadata were found in memory
F
RELOADS
: Any
PIN
of the object, following the first after object creation, which
requires loading the object from disk
F
INVALIDATIONS
: The number of times objects in the namespace were marked
invalid due to dependent object modifications