DBA Data[Home] [Help]

VIEW: SYS.DBA_ALERT_ARGUMENTS

Source

View Text - Preformatted

SELECT sequence_id,
            mid_keltsd AS reason_message_id,
            npm_keltsd AS reason_argument_count,
            reason_argument_1,
            reason_argument_2,
            reason_argument_3,
            reason_argument_4,
            reason_argument_5,
            amid_keltsd AS action_message_id,
            anpm_keltsd AS action_argument_count,
            action_argument_1,
            action_argument_2,
            action_argument_3,
            action_argument_4,
            action_argument_5
    FROM wri$_alert_outstanding, X$KELTSD
    WHERE reason_id = rid_keltsd
View Text - HTML Formatted

SELECT SEQUENCE_ID
, MID_KELTSD AS REASON_MESSAGE_ID
, NPM_KELTSD AS REASON_ARGUMENT_COUNT
, REASON_ARGUMENT_1
, REASON_ARGUMENT_2
, REASON_ARGUMENT_3
, REASON_ARGUMENT_4
, REASON_ARGUMENT_5
, AMID_KELTSD AS ACTION_MESSAGE_ID
, ANPM_KELTSD AS ACTION_ARGUMENT_COUNT
, ACTION_ARGUMENT_1
, ACTION_ARGUMENT_2
, ACTION_ARGUMENT_3
, ACTION_ARGUMENT_4
, ACTION_ARGUMENT_5
FROM WRI$_ALERT_OUTSTANDING
, X$KELTSD
WHERE REASON_ID = RID_KELTSD