4.17 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 of the task |
|
|
|
Unique identifier of the task |
|
|
|
Name of the task |
|
|
|
Name of the task execution with which this entry (row) is associated |
|
|
|
Type of the last execution. This information is optional for single-execution tasks. |
|
|
|
Name of the parameter |
|
|
|
Value of the parameter. Numeric parameter values are converted to a string equivalent. |
|
|
|
Datatype of the parameter (see |
|
|
|
Indicates whether the parameter value is set to the advisor's default value ( |
|
|
|
Indicates whether the task execution process sets the parameter value ( |
|
|
|
Indicates whether the parameter value can be modified when the task is not in its initial state ( |
|
|
|
Optional description of the parameter |
|
|
|
Reserved for internal use |
|
|
|
Reserved for internal use |
See Also: