Description
This alert calculates the Oracle library cache miss ratio.
ALERT DEFINITION
To create the alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Single Numeric Return. Configure the alert with values similar to these:
Alert Name: Library Cache Miss Ratio
Execution Interval: 10 Minutes
Notification Text: The library cache miss ratio has exceeded threholds
SQL Statement:
SELECT 100-(SUM(PINS-RELOADS)/SUM(PINS)*100) FROM V$LIBRARYCACHE
Execute Against: Monitored Instance
Units: Miss Ratio
High Threshold: Min 5, Max empty
Medium Threshold: Min 2, Max 5
