Oracle Developer Jr - READY TO HIRE! Next Step Systems US-CA-Thousand Oaks Post A Job | Post A Resume

SQL 1: Library Cache

select Sum (pins) as Executions
,Sum (reloads) as Misses
     ,( (Sum (pins) / Sum (reloads) ) /
(Sum (pins) + Sum (reloads) )) * 100 as reloads
     ,(1 - ( (Sum (pins) / Sum (reloads) )
/ (Sum (pins) + Sum (reloads) ) )) * 100 as pins
from v$library