Shared Pool - Request Failure

SQL Statement

select request_failures from v$shared_pool_reserved@#DBLINK#;

Description

This custom alert will send an alert anytime a request failure is identified in the Oracle shared pool. If the number of request failures is between one and five, the alert will be sent to "All DBAs" group, and sent to the "On Call" group anytime the value is above six.

For more information about Writing Custom Alerts, see PG110.