SQL Statement

SELECT 100-(SUM(PINS-RELOADS)/SUM(PINS)*100) FROM V$LIBRARYCACHE

Description

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