Custom Ignite Alert: Monitoring the Oracle Alert Log (11g+)#LR14341
The custom Ignite alert log file is now exposed within an Oracle database via the table named X$DBGALERTEXT. Ignite can query this table via a custom alert to look for specific errors such as ORA-600, or anything that appears in this table. Below is a example of an alert that looks for any Oracle error (denoted by "ORA-" in the message text).
Ignite must be given privilege to read the X$DBGALERTEXT table before this alert will function.
select substr(MESSAGE_TEXT, 1, 300) message_text, count(*) cnt from X$DBGALERTEXT where (MESSAGE_TEXT like '%ORA-%' or upper(MESSAGE_TEXT) like '%ERROR%') and cast(ORIGINATING_TIMESTAMP as DATE) > sysdate - #FREQUENCY#/1440 group by substr(MESSAGE_TEXT, 1, 300);
Ignite alert definition