Library Cache Hit ratio is good, Reload ration is bad. The next move?
Dan AMay 19 2008 — edited May 19 2008Oracle 9i AIX
Running this to assertain the Library Cahce Hit ratio
select sum (PINS-RELOADS) / SUM(PINS) *100 "Library Cache Hit Ratio"
from v$librarycache;
Getting constants over 99% = GOOD
Then also running this to see the Reload ratio:
select sum(pins) "Executions", sum(reloads) "Misses", sum(reloads)/sum(pins) "Reload Ratio"
from v$librarycache;
and equally consistently receiving 3% - 4% resultrs = NOT GOOD.
The next (to sugges to our DBA) would be what?
Take a look at V$DB_OBJECT_CACHE to see which objects are cached in the shared pool?
Then explain to him that the objects found there, higher than 10000 and not kept, should be moved to the shared pool?
This is the text book / documentation response - I just wanted to know if anyone out there has another / alternative approach.
Thank you.
DA