ORACLE: ALERTS

To check for errors, check Alert logs.

Additionally, Oracle provides the following views.

SQL> SELECT * FROM DICTIONARY WHERE TABLE_NAME LIKE '%ALERT%';
SQL> column table_name format a30
SQL> column comments format a40
SQL> /

TABLE_NAME                     COMMENTS
------------------------------ ----------------------------------------
DBA_OUTSTANDING_ALERTS         Description of all outstanding alerts
DBA_ALERT_HISTORY              Description on alert history
DBA_ALERT_ARGUMENTS            Message Id and arguments of outstanding
                               alerts

DBMS_ALERT_INFO
V$ALERT_TYPES                  Synonym for V_$ALERT_TYPES
GV$ALERT_TYPES                 Synonym for GV_$ALERT_TYPES

6 rows selected.