[Home] [Help] [Dependency Information]

TABLE: SYS.WRI$_ADV_PARAMETERS

Object Details

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Primary Key: WRI$_ADV_PARAMETERS_PK

1. TASK_ID
2. NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
WRI$_ADV_PARAMETERS_PK	NORMAL	UNIQUE	SYSAUX	TASK_ID NAME

Columns

Query Text

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

SELECT TASK_ID
,      NAME
,      VALUE
,      DATATYPE
,      FLAGS
,      DESCRIPTION
FROM SYS.WRI$_ADV_PARAMETERS;

Dependencies

[top of page]

SYS.WRI$_ADV_PARAMETERS does not reference any database object

SYS.WRI$_ADV_PARAMETERS is referenced by following:

SYS

DBA_ADVISOR_EXEC_PARAMETERS

DBA_ADVISOR_PARAMETERS

DBA_ADVISOR_PARAMETERS_PROJ

DBA_ADVISOR_SQLW_PARAMETERS

DBMS_ADVISOR - 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_WORKLOAD - show dependent code

USER_ADVISOR_EXEC_PARAMETERS

USER_ADVISOR_PARAMETERS

USER_ADVISOR_SQLW_PARAMETERS

WRI$_ADV_COMPRESSION_T

WRI$_ADV_OBJSPACE_TREND_T