Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-15
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_EXEC_PARAMETERS

DBA_ADVISOR_EXEC_PARAMETERS displays the parameter values used for past executions of tasks. It is more useful for advisors supporting multiple executions, such as SQL Performance Analyzer, where a parameter can have different values for different executions.

Related View

USER_ADVISOR_EXEC_PARAMETERS displays the parameter values used for past executions of tasks owned by the current user.

Column Datatype NULL Description
OWNER VARCHAR2(30)   Owner of the task
TASK_ID NUMBER NOT NULL Unique identifier of the task
TASK_NAME VARCHAR2(30)   Name of the task
EXECUTION_NAME VARCHAR2(30) NOT NULL Name of the task execution with which this entry (row) is associated
EXECUTION_TYPE VARCHAR2(30)   Type of the last execution. This information is optional for single-execution tasks.
PARAMETER_NAME VARCHAR2(30) NOT NULL Name of the parameter
PARAMETER_VALUE VARCHAR2(4000)   Value of the parameter. Numeric parameter values are converted to a string equivalent.
PARAMETER_TYPE VARCHAR2(10)   Datatype of the parameter (see DBA_ADVISOR_PARAMETERS)
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)
DESCRIPTION VARCHAR2(4000)   Optional description of the parameter
PARAMETER_FLAGS NUMBER NOT NULL Reserved for internal use
PARAMETER_TYPE# NUMBER NOT NULL Reserved for internal use