SQL Statement

select request_failures from v$shared_pool_reserved

Description

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.