set pagesize 999
prompt 
prompt 
prompt Monitoring the Library Cache ... (v$librarycache)
prompt 

select sum(pins) "Executions",
       sum(reloads) "Cache Misses while Executing" , 
       sum(pins)*100/(sum(reloads)+sum(pins)) "Ratio"
       from v$librarycache;
prompt  
prompt Ratio should be greater than 99%

prompt
prompt Monitoring the Data Dictionary cache ...
prompt
select sum(gets) "data dictionary gets" ,
       sum(getmisses) "Data Dict Cache Get Misses ",
       sum(getmisses)*100/(sum(gets)+sum(getmisses)) "Ratio"
       from v$rowcache;
prompt 
prompt Ratio should be less than 10% - 15% 
prompt