Category Archives: Oracle

In this we are handling Oracle Database Administration and development task. If provide solution of ORA Errors and configuration Steps for setup in Oracle.

Find Dictionary cache hit ratio in Oracle

Find Dictionary cache hit ratio in Oracle

A cache hit ratio should be more than 95 percent considered good in Oracle.
When we start the database its first time load all the data dictionary cache. so that time you will get the value less.
If value is getting less than 95% then probably we need to increase the size of the SHARED_POOL_SIZE parameter.

Find the dictionary Cache hit ratio

select sum(gets) as "Gets", sum(getmisses) as "Misses", (1-(sum(getmisses)/sum(gets)))*100 as "CACHE HIT RATIO"
from gv$rowcache;