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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: SYS.WRI$_ALERT_HISTORY

Object Details

Object Name:	WRI$_ALERT_HISTORY
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Primary Key: WRI$_ALERT_HISTORY_PK

SEQUENCE_ID
STATE_TRANSITION_NUMBER

Indexes

Index	Type	Uniqueness	Tablespace	Column
WRI$_ALERT_HISTORY_PK	NORMAL	UNIQUE	SYSAUX	SEQUENCE_ID STATE_TRANSITION_NUMBER

Columns

Name	Datatype	Length	Mandatory
SEQUENCE_ID	NUMBER		Yes
REASON_ID	NUMBER
OWNER	VARCHAR2	(128)
OBJECT_NAME	VARCHAR2	(513)
SUBOBJECT_NAME	VARCHAR2	(128)
REASON_ARGUMENT_1	VARCHAR2	(581)
REASON_ARGUMENT_2	VARCHAR2	(581)
REASON_ARGUMENT_3	VARCHAR2	(581)
REASON_ARGUMENT_4	VARCHAR2	(581)
REASON_ARGUMENT_5	VARCHAR2	(581)
TIME_SUGGESTED	TIMESTAMP(6) WITH TIME ZONE	(13)
CREATION_TIME	TIMESTAMP(6) WITH TIME ZONE	(13)
ACTION_ARGUMENT_1	VARCHAR2	(128)
ACTION_ARGUMENT_2	VARCHAR2	(128)
ACTION_ARGUMENT_3	VARCHAR2	(128)
ACTION_ARGUMENT_4	VARCHAR2	(128)
ACTION_ARGUMENT_5	VARCHAR2	(128)
MESSAGE_LEVEL	NUMBER
HOSTING_CLIENT_ID	VARCHAR2	(64)
PROCESS_ID	VARCHAR2	(128)
HOST_ID	VARCHAR2	(256)
HOST_NW_ADDR	VARCHAR2	(256)
INSTANCE_NAME	VARCHAR2	(16)
INSTANCE_NUMBER	NUMBER
USER_ID	VARCHAR2	(128)
EXECUTION_CONTEXT_ID	VARCHAR2	(128)
ERROR_INSTANCE_ID	VARCHAR2	(142)
RESOLUTION	NUMBER
METRIC_VALUE	NUMBER
STATE_TRANSITION_NUMBER	NUMBER		Yes
PDB_NAME	VARCHAR2	(128)
CON_ID	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SEQUENCE_ID
,      REASON_ID
,      OWNER
,      OBJECT_NAME
,      SUBOBJECT_NAME
,      REASON_ARGUMENT_1
,      REASON_ARGUMENT_2
,      REASON_ARGUMENT_3
,      REASON_ARGUMENT_4
,      REASON_ARGUMENT_5
,      TIME_SUGGESTED
,      CREATION_TIME
,      ACTION_ARGUMENT_1
,      ACTION_ARGUMENT_2
,      ACTION_ARGUMENT_3
,      ACTION_ARGUMENT_4
,      ACTION_ARGUMENT_5
,      MESSAGE_LEVEL
,      HOSTING_CLIENT_ID
,      PROCESS_ID
,      HOST_ID
,      HOST_NW_ADDR
,      INSTANCE_NAME
,      INSTANCE_NUMBER
,      USER_ID
,      EXECUTION_CONTEXT_ID
,      ERROR_INSTANCE_ID
,      RESOLUTION
,      METRIC_VALUE
,      STATE_TRANSITION_NUMBER
,      PDB_NAME
,      CON_ID
FROM SYS.WRI$_ALERT_HISTORY;

Dependencies

[top of page]

SYS.WRI$_ALERT_HISTORY does not reference any database object

SYS.WRI$_ALERT_HISTORY is referenced by following:

SYS: DBMS_WRR_INTERNAL - show dependent code; INT$DBA_ALERT_HISTORY; INT$DBA_ALERT_HISTORY_DETAIL