Oracle 视图 DBA_ADVISOR_EXEC_PARAMETERS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_ADVISOR_EXEC_PARAMETERS用来查询SQL或AWR Advisor执行时的参数状态，列出每个参数的执行时值和计算后的建议值。该视图通过DBA_ADVISOR_FINDINGS视图来监视Advisor推荐，并在实施推荐后追踪参数值及变化。这个视图涵盖实施推荐前后的所有参数变化。
要使用该视图，可以以下查询：
select * from 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:
“USER_ADVISOR_EXEC_PARAMETERS”
