📋Steps in this guide1/1

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;

oracle configurationintermediate

by OracleDba

14 views

Dictionary cache hit ratio

Code/Command (click line numbers to comment):

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.

Comments (0)

Please to add comments

No comments yet. Be the first to comment!