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.DIR$ALERT_HISTORY

Object Details

Object Name:	DIR$ALERT_HISTORY
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
I_DIR$ALERT_HISTORY_ACTION_ID	NORMAL	NONUNIQUE	SYSAUX	ACTION_ID
I_DIR$ALERT_HISTORY_AT	NORMAL	NONUNIQUE	SYSAUX	ACTION_TIME
I_DIR$ALERT_HISTORY_NAME	NORMAL	NONUNIQUE	SYSAUX	ALERT_NAME
I_DIR$ALERT_HISTORY_REASON_ID	NORMAL	NONUNIQUE	SYSAUX	REASON_ID

Columns

Name	Datatype	Length
ALERT_NAME	VARCHAR2	(200)
MESSAGE_LEVEL	NUMBER
ACTION_ID	NUMBER
REASON_ID	NUMBER
LAST_TIME	DATE
NEXT_TIME	DATE
ACTION_TIME	DATE
INCARNATION_INFO	VARCHAR2	(4000)
JOB_NAME	VARCHAR2	(100)
SPAREN1	NUMBER
SPAREN2	NUMBER
SPAREN3	NUMBER
SPAREN4	NUMBER
SPAREN5	NUMBER
SPAREVC1	VARCHAR2	(4000)
SPAREVC2	VARCHAR2	(4000)
SPAREVC3	VARCHAR2	(4000)
SPAREVC4	VARCHAR2	(4000)
SPAREVC5	VARCHAR2	(4000)

Query Text

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


SELECT ALERT_NAME
,      MESSAGE_LEVEL
,      ACTION_ID
,      REASON_ID
,      LAST_TIME
,      NEXT_TIME
,      ACTION_TIME
,      INCARNATION_INFO
,      JOB_NAME
,      SPAREN1
,      SPAREN2
,      SPAREN3
,      SPAREN4
,      SPAREN5
,      SPAREVC1
,      SPAREVC2
,      SPAREVC3
,      SPAREVC4
,      SPAREVC5
FROM SYS.DIR$ALERT_HISTORY;

Dependencies

[top of page]

SYS.DIR$ALERT_HISTORY does not reference any database object

SYS.DIR$ALERT_HISTORY is not referenced by any database object