Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-23
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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(128) NOT NULL Name of the advisor that supports the parameter
PARAMETER_NAME VARCHAR2(128) 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)
IS_OUTPUT VARCHAR2(1)   Indicates whether the task execution process sets the parameter value (Y) or not (N)
IS_MODIFIABLE_ANYTIME VARCHAR2(1)   Indicates whether the parameter value can be modified when the task is not in its initial state (Y) or not (N)
IS_SYSTEM_TASK_ONLY VARCHAR2(1)   Indicates whether the task is a system task (Y) or not (N)
DESCRIPTION VARCHAR2(4000)   Optional description of the parameter
EXECUTION_TYPE VARCHAR2(128)   Type of the last execution. This information is optional for single-execution tasks.