/*
Data dictionary cache miss ratio.
Looking for a good percentage hit rate.
*/

select sum(gets) “Gets”, sum(getmisses) “Misses”,
(1 – (sum(getmisses) / (sum(gets) +
sum(getmisses))))*100 “HitRate”
from v$rowcache;

How to get the data dictionary cache miss ratio

Leave a Reply

Your email address will not be published. Required fields are marked *

+ 34 = thirty seven