/* 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;
/* 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;