4.21 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(128)

Owner of the task

TASK_ID

NUMBER

NOT NULL

Unique identifier of the task

TASK_NAME

VARCHAR2(128)

Name of the task

EXECUTION_NAME

VARCHAR2(128)

NOT NULL

Name of the task execution with which this entry (row) is associated

EXECUTION_TYPE

VARCHAR2(128)

Type of the last execution. This information is optional for single-execution tasks.

PARAMETER_NAME

VARCHAR2(128)

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