Library Cache Hit Ratio

SQL Statement

SELECT round((sum(reloads)/sum(pins)),3.2) FROM V$LIBRARYCACHE@#DBLINK#

Description

This custom alert executes once per hour and calculates the Oracle library cache miss ratio. If this value is above 2%, which is equivalent to a 98% hit ratio, an alert will be sent to the "On Call" group of DBAs.

For more information about Writing Custom Alerts, see PG110.