Custom Alerts with Ignite™ for Oracle

Overview

Custom Alerts enable a user to execute SQL statements or stored procedures against the Monitored database to check for customized, site specific conditions and to generate an Alert when these conditions are met. Any parameter that can be returned to Ignite for Oracle using a SQL or stored procedure can be used as the basis for a Custom Alert.

How to Create Your Own Custom Alerts

For more information about Writing Custom Alerts, see PG110.

Custom Alert Library

1. Current Shared Pool Size - Calculates the current size of the Oracle shared pool and sends an alert to "All DBAs" if it's larger than 70 MB.
2. Library Cache Hit Ratio - Executes once per hour and calculates the Oracle library cache miss ratio. If this value is above 2%, which is equivalent to a 98% hit ratio, an alert will be sent to the "On Call" group of DBAs.
3. Number of Oracle Sessions - Counts the number of user sessions currently connected to the database and alerts the "DBAs" when that exceeds 100.
4. Shared Pool - Request Failure -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.
5. Login Failures - If your Oracle database is configured for auditing, this alert will monitor for logon failures and alert the DBA group. It runs once every hour and looks for logon failures from the last hour.
6. Blocking Locks - Provides notification when locking wait events are found in the selected databases.
7. RAC Overhead - Calculates the cumulative amount of RAC wait time overhead from the last hour for each instance.
8. Quickpoll Monitor - Notifies you when a process is no longer running for the selected databases or if the process is running but has not collected data for over 30 minutes.
9. Space Alert - This alert provides notification when the maximum chunk of free space within a tablespace is smaller than 2 * next_extent size of any object contained in it.

A Custom Alert Example

Current Shared Pool Size