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_OUTSTANDING

Object Details

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

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Primary Key: WRI$_ALERT_OUTSTANDING_PK

CON_ID
REASON_ID
OBJECT_ID
SUBOBJECT_ID
INTERNAL_INSTANCE_NUMBER

Indexes

Index	Type	Uniqueness	Tablespace	Column
WRI$_ALERT_OUTSTANDING_PK	NORMAL	UNIQUE	SYSAUX	CON_ID REASON_ID OBJECT_ID SUBOBJECT_ID INTERNAL_INSTANCE_NUMBER

Columns

Name	Datatype	Length	Mandatory
REASON_ID	NUMBER		Yes
OBJECT_ID	NUMBER		Yes
SUBOBJECT_ID	NUMBER		Yes
INTERNAL_INSTANCE_NUMBER	NUMBER		Yes
OWNER	VARCHAR2	(128)
OBJECT_NAME	VARCHAR2	(513)
SUBOBJECT_NAME	VARCHAR2	(128)
SEQUENCE_ID	NUMBER
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)
CONTEXT	RAW	(128)
METRIC_VALUE	NUMBER
STATE_TRANSITION_NUMBER	NUMBER
PDB_NAME	VARCHAR2	(128)
CON_ID	NUMBER		Yes

Query Text

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


SELECT REASON_ID
,      OBJECT_ID
,      SUBOBJECT_ID
,      INTERNAL_INSTANCE_NUMBER
,      OWNER
,      OBJECT_NAME
,      SUBOBJECT_NAME
,      SEQUENCE_ID
,      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
,      CONTEXT
,      METRIC_VALUE
,      STATE_TRANSITION_NUMBER
,      PDB_NAME
,      CON_ID
FROM SYS.WRI$_ALERT_OUTSTANDING;

Dependencies

[top of page]

SYS.WRI$_ALERT_OUTSTANDING does not reference any database object

SYS.WRI$_ALERT_OUTSTANDING is referenced by following:

SYS: DBA_ALERT_ARGUMENTS; DBMS_PROPAGATION_INTERNAL - show dependent code; DBMS_SERVER_ALERT_PRVT - show dependent code; DBMS_SPACE - show dependent code; INT$DBA_OUTSTANDING_ALERTS