DBA_ADVISOR_DEF_PARAMETERS

DBA_ADVISOR_DEF_PARAMETERS displays all default task parameters and their current values in the database. When a task or object is created, the parameters and their values are copied into the private parameter table.

Column

Datatype

NULL

Description

ADVISOR_NAME

VARCHAR2(30)

NOT NULL

Name of the advisor that supports the parameter

PARAMETER_NAME

VARCHAR2(30)

NOT NULL

Name of the parameter

PARAMETER_VALUE

VARCHAR2(4000)

NOT NULL

Value of the parameter. Numeric parameter values are converted to a string equivalent.

Possible keywords as values:

ALL

UNLIMITED

UNUSED

PARAMETER_TYPE

VARCHAR2(10)

Datatype of the parameter:

NUMBER - Numeric value

STRING - String value. If the string contains special characters, then it will be enclosed in single quotes.

STRINGLIST - Comma-separated list of string elements. If a string element contains a comma or other special characters, then the element will be enclosed in single quotes.

TABLE - Single table reference. A reference will contain a schema name, followed by an optional table name.

If the table name is omitted or is the character %, then the table name is interpreted as a wildcard. SQL quoted identifiers are supported.

TABLELIST - List of one or more comma-separated table references. A reference will contain schema name, followed by an optional table name.

If the table name is omitted or is the character %, then the table name is interpreted as a wildcard. SQL quoted identifiers are supported.

IS_DEFAULT

VARCHAR2(1)

Indicates whether the parameter value is set to the advisor's default value (Y) or not (N)