Showing results for 
Search instead for 
Did you mean: 
Create Post

Custom Alert - Shared Pool Request Failures


Will send an alert anytime a request failure is identified in the Oracle shared pool.


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

Labels (1)
Version history
Revision #:
1 of 1
Last update:
‎01-08-2014 07:35 AM
Updated by: