Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

Part Number B10755-01
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
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

DBA_ADVISOR_PARAMETERS

DBA_ADVISOR_PARAMETERS displays the parameters and their current values for all tasks in the database.


Related View

USER_ADVISOR_PARAMETERS displays the parameters and their current values for the tasks owned by the current user. This view does not display the OWNER column.

Column Datatype NULL Description
OWNER VARCHAR2(30)   Owner of the task or workload object
TASK_ID NUMBER NOT NULL Unique identifier number of the task or workload object
TASK_NAME VARCHAR2(30)   Name of the task or workload object
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, 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.