NAMESPACE |
VARCHAR2(15) |
The library cache namespace |
GETS |
NUMBER |
The number of times a lock was requested for objects of this namespace |
GETHITS |
NUMBER |
The number of times an object's handle was found in memory |
GETHITRATIO |
NUMBER |
The ratio of GETHITS to GETS |
PINS |
NUMBER |
The number of times a PIN was requested for objects of this namespace |
PINHITS |
NUMBER |
The number of times all of the metadata pieces of the library object were found in memory |
PINHITRATIO |
NUMBER |
The ratio of PINHITS to PINS |
RELOADS |
NUMBER |
Any PIN of an object that is not the first PIN performed since the object handle was created, and which requires loading the object from disk |
INVALIDATIONS |
NUMBER |
The total number of times objects in this namespace were marked invalid because a dependent object was modified |
DLM_LOCK_REQUESTS |
NUMBER |
The number of GET requests lock instance locks |
DLM_PIN_REQUESTS |
NUMBER |
The number of PIN requests lock instance locks |
DLM_PIN_RELEASES |
NUMBER |
The number of release requests PIN instance locks |
DLM_INVALIDATION_REQUESTS |
NUMBER |
The number of GET requests for invalidation instance locks |
DLM_INVALIDATIONS |
NUMBER |
The number of invalidation pings received from other instances |