Description
Will send an alert anytime a request failure is identified in the Oracle shared pool.
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: Shared Pool Request Failures
Execution Interval: 1 Hour
Notification Text: There have been shared pool request failures
SQL Statement:
select request_failures from v$shared_pool_reserved
Execute Against: Monitored Instance
Units: Failures
High Threshold: Min 6, Max empty
Medium Threshold: Min 1, Max 5
