SELECT SUM(PINS) HITS,SUM(RELOADS) MISSES,(SUM(PINS)/SUM(PINS)+SUM(RELOADS)) HITRATIO
FROM V$LIBRARYCACHE
/