LIBRARY CACHE HIT RATIO AND EXECUTION MISSES

The following SQL statement help you to calculate the library cache hit ratio:

SELECT
SUM(PINS) "EXECUTIONS",
SUM(RELOADS) "CACHE MISSES WHILE EXECUTING"
FROM
V$LIBRARYCACHE;

If the ratio of misses to executions is more than 1%, then try to reduce the library cache misses by increasing the shared pool size.