[Home] [Help] [Dependency Information]

TABLE: SYS.WRI$_ADV_RECOMMENDATIONS

Object Details

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Primary Key: WRI$_ADV_REC_PK

1. TASK_ID
2. ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
WRI$_ADV_RECS_IDX_01	NORMAL	UNIQUE	SYSAUX	TASK_ID EXEC_NAME ID
WRI$_ADV_RECS_IDX_02	NORMAL	UNIQUE	SYSAUX	TASK_ID EXEC_NAME FINDING_ID ID
WRI$_ADV_REC_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
,      FINDING_ID
,      RANK
,      PARENT_RECS
,      BENEFIT_MSG_ID
,      BENEFIT_VAL
,      ANNOTATION
,      FLAGS
,      FILTERED
,      EXEC_NAME
FROM SYS.WRI$_ADV_RECOMMENDATIONS;

Dependencies

[top of page]

SYS.WRI$_ADV_RECOMMENDATIONS does not reference any database object

SYS.WRI$_ADV_RECOMMENDATIONS is referenced by following:

SYS

DBA_ADVISOR_RECOMMENDATIONS

DBMS_FEATURE_SEGADV_USER - show dependent code

DBMS_SPACE - show dependent code

DBMS_SQLTUNE_INTERNAL - show dependent code

PRVT_ACCESS_ADVISOR - show dependent code

PRVT_ADVISOR - show dependent code

PRVT_HDM - show dependent code

PRVT_SYS_TUNE_MVIEW - show dependent code

USER_ADVISOR_RECOMMENDATIONS

WRI$_ADV_OBJSPACE_TREND_T

_DBA_STREAMS_RECOMMENDATIONS