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]

VIEW: SYS._DBA_STREAMS_ACTIONS

Object Details

Object Name:	_DBA_STREAMS_ACTIONS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

DBA Streams Actions

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
MESSAGE_ID	NUMBER			ID of the action message
MESSAGE_ARG1	VARCHAR2	(4000)		Argument 1 to the action message
MESSAGE_ARG2	VARCHAR2	(4000)		Argument 2 to the action message
MESSAGE_ARG3	VARCHAR2	(4000)		Argument 3 to the action message
MESSAGE_ARG4	VARCHAR2	(4000)		Argument 4 to the action message
MESSAGE_ARG5	VARCHAR2	(4000)		Argument 5 to the action message
COMMAND	VARCHAR2	(64)		Command to run to execute the action
COMMAND_ID	NUMBER		Yes	ID of the command to run
FLAGS	NUMBER			Flags associated with the action
ATTR1	VARCHAR2	(4000)		Attribute 1
ATTR2	VARCHAR2	(4000)		Attribute 2
ATTR3	VARCHAR2	(4000)		Attribute 3
ATTR4	VARCHAR2	(4000)		Attribute 4
ATTR5	CLOB	(4000)		Attribute 5
ATTR6	CLOB	(4000)		Attribute 6
NUM_ATTR1	NUMBER			Attribute 1 in number format
NUM_ATTR2	NUMBER			Attribute 2 in number format
NUM_ATTR3	NUMBER			Attribute 3 in number format
NUM_ATTR4	NUMBER			Attribute 4 in number format
NUM_ATTR5	NUMBER			Attribute 5 in number format
ADVISOR_TYPE	VARCHAR2	(128)		Type of the advisor (PERFORMANCE, CONFIGURATION, ERROR)
RUN_TIME	DATE			Time that the advisor was run

Query Text

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


SELECT MESSAGE_ID
,      MESSAGE_ARG1
,      MESSAGE_ARG2
,      MESSAGE_ARG3
,      MESSAGE_ARG4
,      MESSAGE_ARG5
,      COMMAND
,      COMMAND_ID
,      FLAGS
,      ATTR1
,      ATTR2
,      ATTR3
,      ATTR4
,      ATTR5
,      ATTR6
,      NUM_ATTR1
,      NUM_ATTR2
,      NUM_ATTR3
,      NUM_ATTR4
,      NUM_ATTR5
,      ADVISOR_TYPE
,      RUN_TIME
FROM SYS._DBA_STREAMS_ACTIONS;

Dependencies

[top of page]

SYS._DBA_STREAMS_ACTIONS references the following:

SYS: WRI$_ADV_ACTIONS; WRI$_ADV_MESSAGE_GROUPS; WRI$_ADV_TASKS

SYS._DBA_STREAMS_ACTIONS is referenced by following:

PUBLIC: _DBA_STREAMS_ACTIONS