SELECT 'Dictionary Cache Hit Ratio ' "Ratio",
ROUND ((1 - (SUM (getmisses) / SUM (gets))) * 100, 2)
|| '%' "Percentage"
FROM v$rowcache;