eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: SYS.INT$DBA_ALERT_HISTORY

Source

View Text - Preformatted


select sequence_id,
            reason_id,
            owner,
            object_name,
            subobject_name,
            typnam_keltosd AS object_type,
            dbms_server_alert.expand_message(userenv('LANGUAGE'),
                                             mid_keltsd,
                                             reason_argument_1,
                                             reason_argument_2,
                                             reason_argument_3,
                                             reason_argument_4,
                                             reason_argument_5,
                                             objidx_keltsd,
                                             pdb_name) AS reason,
            time_suggested,
            creation_time,
            dbms_server_alert.expand_message(userenv('LANGUAGE'),
                                             amid_keltsd,
                                             action_argument_1,
                                             action_argument_2,
                                             action_argument_3,
                                             action_argument_4,
                                             action_argument_5)
              AS suggested_action,
            advisor_name,
            metric_value,
            decode(message_level, 32, 'Notification', 'Warning')
              AS message_type,
            nam_keltgsd AS message_group,
            message_level,
            hosting_client_id,
            mdid_keltsd AS module_id,
            process_id,
            host_id,
            host_nw_addr,
            instance_name,
            instance_number,
            user_id,
            execution_context_id,
            error_instance_id,
            decode(resolution, 1, 'cleared', 'N/A') AS resolution,
            pdb_name,
            h.con_id as con_id
  FROM wri$_alert_history h, X$KELTSD a, X$KELTOSD, X$KELTGSD,
       dba_advisor_definitions
  WHERE resolution != 2
    AND reason_id = rid_keltsd
    AND otyp_keltsd = typid_keltosd
    AND grp_keltsd = id_keltgsd
    AND aid_keltsd = advisor_id(+)

View Text - HTML Formatted

SELECT SEQUENCE_ID
, REASON_ID
, OWNER
, OBJECT_NAME
, SUBOBJECT_NAME
, TYPNAM_KELTOSD AS OBJECT_TYPE
, DBMS_SERVER_ALERT.EXPAND_MESSAGE(USERENV('LANGUAGE')
, MID_KELTSD
, REASON_ARGUMENT_1
, REASON_ARGUMENT_2
, REASON_ARGUMENT_3
, REASON_ARGUMENT_4
, REASON_ARGUMENT_5
, OBJIDX_KELTSD
, PDB_NAME) AS REASON
, TIME_SUGGESTED
, CREATION_TIME
, DBMS_SERVER_ALERT.EXPAND_MESSAGE(USERENV('LANGUAGE')
, AMID_KELTSD
, ACTION_ARGUMENT_1
, ACTION_ARGUMENT_2
, ACTION_ARGUMENT_3
, ACTION_ARGUMENT_4
, ACTION_ARGUMENT_5) AS SUGGESTED_ACTION
, ADVISOR_NAME
, METRIC_VALUE
, DECODE(MESSAGE_LEVEL
, 32
, 'NOTIFICATION'
, 'WARNING') AS MESSAGE_TYPE
, NAM_KELTGSD AS MESSAGE_GROUP
, MESSAGE_LEVEL
, HOSTING_CLIENT_ID
, MDID_KELTSD AS MODULE_ID
, PROCESS_ID
, HOST_ID
, HOST_NW_ADDR
, INSTANCE_NAME
, INSTANCE_NUMBER
, USER_ID
, EXECUTION_CONTEXT_ID
, ERROR_INSTANCE_ID
, DECODE(RESOLUTION
, 1
, 'CLEARED'
, 'N/A') AS RESOLUTION
, PDB_NAME
, H.CON_ID AS CON_ID
FROM WRI$_ALERT_HISTORY H
, X$KELTSD A
, X$KELTOSD
, X$KELTGSD
, DBA_ADVISOR_DEFINITIONS
WHERE RESOLUTION != 2
AND REASON_ID = RID_KELTSD
AND OTYP_KELTSD = TYPID_KELTOSD
AND GRP_KELTSD = ID_KELTGSD
AND AID_KELTSD = ADVISOR_ID(+)