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