Library Cache SQL

The following query uses the V$LIBRARYCACHE view to examine the reload ratio in the library cache:

select Sum(Pins) "Hits",

Sum(Reloads) "Misses",

((Sum(Reloads) / Sum(Pins)) * 100)"Reload %"

from V$LibraryCache;