Library Cache Hit Ratio.

select sum(pins) Executions, sum(pinhits) "Execution Hits",
((sum(pinhits) / sum(pins)) * 100) phitrat,
sum(reloads) Misses,
((sum(pins) / (sum(pins) + sum(reloads))) * 100) hitrat
from v$librarycache;

How to find the library cache hit ratio

Leave a Reply

Your email address will not be published. Required fields are marked *

eighty seven − = 83