V$LIBRARYCACHE

Displays statistics on library cache activity.

Fields

The most relevant view fields are:

• NAMESPACE: The library cache namespace

• GETS: The number of times a lock was requested for objects in the namespace

• GETHITRATIO: The number of times the object's handle was found in memory

• PINS: The number of times a PIN was requested for objects in the namespace

• PINHITRATIO: The number of times the object's metadata were found in memory

• RELOADS: Any PIN of the object, following the first after object creation, which requires loading the object from disk

• INVALIDATIONS: The number of times objects in the namespace were marked invalid due to dependent object modifications