Custom Ignite Alert: Oracle Library Cache Miss Ratio#LR14343
This custom Ignite alert 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.
SELECT 100-(SUM(PINS-RELOADS)/SUM(PINS)*100) FROM V$LIBRARYCACHE
Ignite alert definition