[Home] [Help] [Dependency Information]

TABLE: SYS.WRI$_ADV_DEF_PARAMETERS

Object Details

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Primary Key: WRI$_ADV_DEF_PARAMETERS_PK

1. ADVISOR_ID
2. NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
WRI$_ADV_DEF_PARAMETERS_PK	NORMAL	UNIQUE	SYSAUX	ADVISOR_ID NAME

Columns

Query Text

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

SELECT ADVISOR_ID
,      NAME
,      DATATYPE
,      FLAGS
,      VALUE
,      DESCRIPTION
,      EXEC_TYPE
FROM SYS.WRI$_ADV_DEF_PARAMETERS;

Dependencies

[top of page]

SYS.WRI$_ADV_DEF_PARAMETERS does not reference any database object

SYS.WRI$_ADV_DEF_PARAMETERS is referenced by following:

SYS

DBA_ADVISOR_DEF_PARAMETERS

DBA_ADVISOR_EXEC_PARAMETERS

DBA_ADVISOR_PARAMETERS

DBMS_ADVISOR - show dependent code

DBMS_SQLTUNE_INTERNAL - show dependent code

PRVT_ACCESS_ADVISOR - show dependent code

PRVT_ADVISOR - show dependent code

PRVT_WORKLOAD - show dependent code

USER_ADVISOR_EXEC_PARAMETERS

USER_ADVISOR_PARAMETERS