<< Click to Display Table of Contents >>

Library Cache

Top Previous Next

The page shows statistics relating to the library cache, where recently used SQL and PL/SQL statements, and Java classes are stored.

The main grid displays the following statistics for each library cache namespace:

Name of the namespace

Pins

Requests (PINS in V$LIBRARYCACHE)

Number of reloads

Reloads as a  percentage of requests

Number of misses (PINS - PINHITS)

Misses as a percentage of requests (1 - PINHITRATIO)

Gets

Number of requests (GETS in v$LIBRARYCACHE)

Number of misses (GETS - GETHITS)

Misses as a percentage of Gets (1 - GETHITRATIO)

Invalidations

Sharable memory

Used

Kept