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.
Note:
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;

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply