huge Dictionary Cache/Miss Ratio count
Hello Experts,
We have 10g standalone database running on 11g RAC environment.Since yesterday we have been observing that there are huge Dictionary Cache/Miss Ratio.
SELECT 'Dictionary Cache', TO_CHAR(SUM(getmisses) / SUM(gets) * 100, '999') "Miss Ratio (%)" FROM V$ROWCACHE;
'DICTIONARYCACHE Miss
---------------- ----
Dictionary Cache 150
select ((1-(Sum(GetMisses) / (Sum(Gets) + Sum(getMisses)))) * 100) "Hit Rate" from v$Rowcache where Gets + GetMisses <> 0;
Hit Rate
----------
- 42.7937522
sga_max_size big integer 2512M
sga_target big integer 2512M
We have not done any recent changes to this database and We could not find any abnormalities from the alert log file and other other traces.Can you please let me know the rason for this and how to overcome this in furture.