[Home] [Help] [Dependency Information]

TABLE: SYS.WRI$_ADV_FINDINGS

Object Details

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Primary Key: WRI$_ADV_FINDINGS_PK

1. TASK_ID
2. ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
WRI$_ADV_FINDINGS_IDX_01	NORMAL	UNIQUE	SYSAUX	TASK_ID EXEC_NAME ID
WRI$_ADV_FINDINGS_IDX_02	NORMAL	UNIQUE	SYSAUX	TASK_ID EXEC_NAME OBJ_ID ID
WRI$_ADV_FINDINGS_PK	NORMAL	UNIQUE	SYSAUX	TASK_ID ID

Columns

Query Text

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

SELECT ID
,      TASK_ID
,      TYPE
,      PARENT
,      OBJ_ID
,      IMPACT_MSG_ID
,      IMPACT_VAL
,      MSG_ID
,      MORE_INFO_ID
,      FILTERED
,      FLAGS
,      EXEC_NAME
,      NAME_MSG_CODE
FROM SYS.WRI$_ADV_FINDINGS;

Dependencies

[top of page]

SYS.WRI$_ADV_FINDINGS does not reference any database object

SYS.WRI$_ADV_FINDINGS is referenced by following:

SYS

DBA_ADVISOR_FINDINGS

DBMS_FEATURE_SEGADV_USER - show dependent code

DBMS_SPACE - show dependent code

DBMS_SQLTUNE_INTERNAL - show dependent code

PRVT_ADVISOR - show dependent code

PRVT_COMPRESSION - show dependent code

PRVT_HDM - show dependent code

PRVT_SQLPA - show dependent code

USER_ADVISOR_FINDINGS

WRI$_ADV_OBJSPACE_TREND_T

_DBA_STREAMS_FINDINGS