Custom Alert - Shared Pool Request Failures

[#1]

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