18.5 Library Cache Hit Ratios

---

These ratios show library cache pre-parsing and reloading activity.

SELECT 'Library Lock Requests' "Ratio"  , ROUND(AVG(gethitratio) * 100, 2)       ||'%' "Percentage" FROM V$LIBRARYCACHE UNION SELECT 'Library Pin Requests' "Ratio", ROUND(AVG    (pinhitratio) * 100, 2)        ||'%' "Percentage" FROM V$LIBRARYCACHE UNION SELECT 'Library I/O Reloads' "Ratio"       , ROUND((SUM(reloads) / SUM(pins)) * 100, 2)       ||'%' "Percentage" FROM V$LIBRARYCACHE UNION SELECT 'Library Reparses' "Ratio"       , ROUND((SUM(reloads) / SUM(pins)) * 100, 2)       ||'%' "Percentage" FROM V$LIBRARYCACHE;     Ratio                     Percentage -----------------------   ---------- Library I/O Reloads       0% Library Lock Requests     96.31% Library Pin Requests      96.1% Library Reparses          0%

---