Skip to content. | Skip to navigation
How to Check the Overall Dictionary Cache Hit Ratio
SELECT (SUM(gets - getmisses)) / SUM(gets) AS "Dictionary Hit Ratio" FROM v$rowcache