I look into the V$librarycache table and I found some info but unclear so please help.
1. PINS of SQL Area=-300932440 ------ why pins is negative ??? but the GETHITRATIO is reasonable =.95
2. The GETHITRATIO on index is very poor=.281731
everything else look ok
can someone give me some hint about the above issues ???
You run the follwoing query in your database.
If % Ratio is above 1% , increase SHARED_POOL_SIZE
Select sum(pins) "Executions",
sum(reloads) "Cache Misses Executing",
sum(reloads)/(sum(pins) * 100) "%Ratio"
Do you mean that the value of GETHITRATIO in v$librarycache is 0.28 for index namespace? Don't worry abou that.
The GETHITRATIO on index is very poor=.281731
select gethitratio from v$librarycache where namespace = 'SQL AREA';
This should be in the high 90s. If not, we cannot do much about it. It is the developers' fault :-)
Click Here to Expand Forum to Full Width