Tables and Views of Oracle Alerts

Tables

Table Name Description
ALR_ACTION_DATA Exceptions found during an action set check
ALR_ACTION_GROUP_MEMBERS Member actions of an alert action group
ALR_ACTION_GROUPS Alert action, threshold, and escalation groups
ALR_ACTION_HISTORY Actual action execution history
ALR_ACTION_OUTPUTS Critical outputs used in a summary action
ALR_ACTION_SET_CHECKS Action set check information
ALR_ACTION_SET_INPUTS Alert action set inputs
ALR_ACTION_SET_MEMBERS Member actions and action groups of alert action sets
ALR_ACTION_SET_OUTPUTS Alert action set outputs
ALR_ACTION_SETS Alert action sets
ALR_ACTIONS Alert and response actions
ALR_ACTUAL_RESPONSES Responses expected and received for an alert message
ALR_ALERT_CHECKS Alert check information
ALR_ALERT_INPUTS Alert inputs
ALR_ALERT_INSTALLATIONS Alert installation information
ALR_ALERT_OUTPUTS Alert outputs
ALR_ALERTS Alerts defined on application tables
ALR_DISTRIBUTION_LISTS Distribution lists
ALR_LOOKUPS Oracle Alert lookup types and codes
ALR_MESSAGE_SYSTEMS Electronic mail system information
ALR_ORACLE_MAIL_ACCOUNTS Oracle*Mail mail account information
ALR_OUTPUT_HISTORY Exception output history
ALR_PERIODIC_SET_MEMBERS Member alerts and periodic sets of periodic sets
ALR_PERIODIC_SETS Periodic alert sets
ALR_PROFILE_OPTIONS Oracle Alert profile options and values
ALR_RESPONSE_ACTION_HISTORY Response processing history
ALR_RESPONSE_ACTIONS Member actions of a response set
ALR_RESPONSE_MESSAGES Messages received in reply to an alert message
ALR_RESPONSE_SETS Response sets
ALR_RESPONSE_VARIABLE_VALUES Actual variable and alert output values returned in a response message
ALR_RESPONSE_VARIABLES Response set variables
ALR_VALID_RESPONSES Response text for each possible response to an alert message

Views

View Name Description
ALR_ACTIONS_V Alert Actions View
ALR_ALERT_ACTIONS_VIEW Actions that are attached to an action set
ALR_ALERT_HISTORY_VIEW All the alert check and alert action history currently stored
ALR_CHECK_ACTION_HISTORY_VIEW All the alert history currently stored
ALR_GROUPS_AND_ACTIONS_VIEW Alert groups and actions for an alert
ALR_INSTALLATIONS_VIEW  
ALR_PERIODIC_ALERTS_VIEW Enabled periodic alerts and their next scheduled check
ALR_RESPONSE_ACTIONS_VIEW All the defined action plus the pre-defined action “Return Original Mail”
ALR_SCHEDULED_PROGRAMS  – Retrofitted
ALR_VARIABLES_AND_OUTPUTS Response variables and outputs for an alert/response set