Dictionary cache hit ratio - Oracle Database Script. SELECT sum(gets) AS "Gets", sum(getmisses) AS "Misses", (1-(sum(getmisses)/sum(gets)))*100 AS "CACHE HIT RATIO" FROM gv$rowcache; NOTE - CACHE HIT RATIO SHOULD BE MORE THAN 95 PERCENT.
SELECT sum(gets) AS "Gets", sum(getmisses) AS "Misses", (1-(sum(getmisses)/sum(gets)))*100 AS "CACHE HIT RATIO" FROM gv$rowcache; NOTE - CACHE HIT RATIO SHOULD BE MORE THAN 95 PERCENT.