REM  #*****************************************************
REM  # File Name: data_dictionary_cache.sql
REM  #
REM  # Purpose: Report the data dictionary cache hit ratio
REM  #
REM  #*****************************************************

select sum(gets) "DC. Gets",
       sum(getmisses) "DC. misses",
       round(((1-(sum(getmisses)/sum(gets)))*100),4) "DC. Hit Ratio"
from v$rowcache;