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]

TYPE: SYS.ALERT_TYPE

Object Details

Object Name:	ALERT_TYPE
Object Type:	TYPE
Owner:	SYS
Subobject Name:	$VSN_1
Status:	VALID

Object Details

Object Name:	ALERT_TYPE
Object Type:	TYPE
Owner:	SYS
Subobject Name:	$VSN_2
Status:	VALID

Object Details

Object Name:	ALERT_TYPE
Object Type:	TYPE
Owner:	SYS
Subobject Name:	$VSN_3
Status:	VALID

Object Details

Object Name:	ALERT_TYPE
Object Type:	TYPE
Owner:	SYS
Subobject Name:
Status:	VALID

Type Details

Type Code:	OBJECT
Predefined:	NO
Incomplete:	NO

Attributes

Name	Datatype	Length
TIMESTAMP_ORIGINATING	TIMESTAMP WITH TZ
ORGANIZATION_ID	VARCHAR2	(10)
COMPONENT_ID	VARCHAR2	(3)
MESSAGE_ID	NUMBER
HOSTING_CLIENT_ID	VARCHAR2	(64)
MESSAGE_TYPE	VARCHAR2	(12)
MESSAGE_GROUP	VARCHAR2	(30)
MESSAGE_LEVEL	NUMBER
HOST_ID	VARCHAR2	(256)
HOST_NW_ADDR	VARCHAR2	(256)
MODULE_ID	VARCHAR2	(64)
PROCESS_ID	VARCHAR2	(128)
USER_ID	VARCHAR2	(30)
UPSTREAM_COMPONENT_ID	VARCHAR2	(30)
DOWNSTREAM_COMPONENT_ID	VARCHAR2	(4)
EXECUTION_CONTEXT_ID	VARCHAR2	(128)
ERROR_INSTANCE_ID	VARCHAR2	(142)
REASON_ARGUMENT_COUNT	NUMBER
REASON_ARGUMENT_1	VARCHAR2	(513)
REASON_ARGUMENT_2	VARCHAR2	(513)
REASON_ARGUMENT_3	VARCHAR2	(513)
REASON_ARGUMENT_4	VARCHAR2	(513)
REASON_ARGUMENT_5	VARCHAR2	(513)
SEQUENCE_ID	NUMBER
REASON_ID	NUMBER
OBJECT_OWNER	VARCHAR2	(30)
OBJECT_NAME	VARCHAR2	(513)
SUBOBJECT_NAME	VARCHAR2	(30)
OBJECT_TYPE	VARCHAR2	(30)
INSTANCE_NAME	VARCHAR2	(16)
INSTANCE_NUMBER	NUMBER
SCOPE	VARCHAR2	(10)
ADVISOR_NAME	VARCHAR2	(30)
METRIC_VALUE	NUMBER
SUGGESTED_ACTION_MSG_ID	NUMBER
ACTION_ARGUMENT_COUNT	NUMBER
ACTION_ARGUMENT_1	VARCHAR2	(30)
ACTION_ARGUMENT_2	VARCHAR2	(30)
ACTION_ARGUMENT_3	VARCHAR2	(30)
ACTION_ARGUMENT_4	VARCHAR2	(30)
ACTION_ARGUMENT_5	VARCHAR2	(30)
PDB_NAME	VARCHAR2	(128)

Dependencies

[top of page]

SYS.ALERT_TYPE references the following:

SYS: STANDARD - show dependent code

SYS.ALERT_TYPE is referenced by following:

PUBLIC: ALERT_TYPE
SYS: ALERT_QT; AQ$ALERT_QT; AQ$_ALERT_QT_F; DBMS_HA_ALERTS - show dependent code; DBMS_HA_ALERTS - show dependent code; DBMS_SERVER_ALERT_PRVT - show dependent code; DBMS_SERVER_ALERT_PRVT - show dependent code; HAEN_TXFM_TEXT