Oracle Alert

What are Oracle Alerts?

Oracle Alerts monitor your Database information and notify you when the condition that you have specified is found. You can define Alerts in any Oracle application or custom Oracle application. Some applications (Purchasing, for example) supply Alerts that Can simply be activated and used. There are two type of Alerts, Event and Periodic.

ALERTS Interview Questions and Answers in Oracle Apps

1.    What are Oracle Alerts?

Oracle Alerts are used to monitor unusual or critical activity within a designated database. The flexibility of ALERTS allows a database administrator the ability to monitor activities from table space sizing to activities associated with particular applications. Alerts can be created to monitor a process in the database and to

Query : To get the list of Custom Alerts

SELECT aa.alert_name, 
aa.creation_date, 
aa.last_update_date,
aa.alert_condition_type,