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

VIEW: SYS._DBA_STREAMS_FINDINGS

Object Details
Object Name: _DBA_STREAMS_FINDINGS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

DBA Streams Findings

[View Source]

Columns
Name Datatype Length Mandatory Comments
MESSAGE_ID NUMBER

ID of the finding message
MESSAGE_ARG1 VARCHAR2 (4000)
Argument 1 to the finding message
MESSAGE_ARG2 VARCHAR2 (4000)
Argument 2 to the finding message
MESSAGE_ARG3 VARCHAR2 (4000)
Argument 3 to the finding message
MESSAGE_ARG4 VARCHAR2 (4000)
Argument 4 to the finding message
MESSAGE_ARG5 VARCHAR2 (4000)
Argument 5 to the finding message
TYPE NUMBER
Yes Type of the finding
MORE_INFO_ID NUMBER

ID for more information related to the finding
INFO_ARG1 VARCHAR2 (4000)
Argument 1 to the finding more info
INFO_ARG2 VARCHAR2 (4000)
Argument 2 to the finding more info
INFO_ARG3 VARCHAR2 (4000)
Argument 3 to the finding more info
INFO_ARG4 VARCHAR2 (4000)
Argument 4 to the finding more info
INFO_ARG5 VARCHAR2 (4000)
Argument 5 to the finding more info
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
,      TYPE
,      MORE_INFO_ID
,      INFO_ARG1
,      INFO_ARG2
,      INFO_ARG3
,      INFO_ARG4
,      INFO_ARG5
,      ADVISOR_TYPE
,      RUN_TIME
FROM SYS._DBA_STREAMS_FINDINGS;

Dependencies

[top of page]

SYS._DBA_STREAMS_FINDINGS references the following:

SchemaSYS
TableWRI$_ADV_FINDINGS
TableWRI$_ADV_MESSAGE_GROUPS
TableWRI$_ADV_TASKS
SYS._DBA_STREAMS_FINDINGS is referenced by following:

SchemaPUBLIC
Synonym_DBA_STREAMS_FINDINGS