Check Library Cache Ratio

ttitle off
btitle off

set pages 100
set lines 132
clear col
clear breaks

prompt *****************************
prompt RELOADRATIO should be low < 1
prompt

select sum(pins), sum(reloads)
, sum(reloads) / sum(pins) * 100 "Reload Ratio"
from v$librarycache
/

prompt
prompt
prompt *****************************
prompt GETHITRATIO should be high > 90%
prompt

select namespace
, gethitratio
, pinhitratio
, reloads
, invalidations
from v$librarycache
/