Oracle High Performance Tuning for 9i and 10g

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%