Sunday, October 3, 2010

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.


No comments:

Post a Comment