Oracle 视图 DBA_ADVISOR_EXECUTIONS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_ADVISOR_EXECUTIONS可查看已经使用Oracle专家计划执行的任务。它可以返回关于在计划执行期间发生的事件、日期和时间以及计划执行结果的信息。
使用该视图，可以查看Oracle专家计划在一段时间内发起执行的任务。可以查看每个任务的执行日期和时间、持续时间和任务执行结果。还可以用于查看指定的任务的执行历史记录、查看给定任务的执行状态。
在Oracle数据库中使用DBA_ADVISOR_EXECUTIONS视图时，需要使用SELECT语句，其格式如下：
SELECT [column_name_list]
FROM DBA_ADVISOR_EXECUTIONS;
其中，[column_name_list]指定要查询的列名，为可选项。这样，可以从DBA_ADVISOR_EXECUTIONS视图获取满足需求的信息。
官方英文解释
DBA_ADVISOR_EXECUTIONS displays metadata information for task executions.
For example, the SQL Performance Analyzer creates a minimum of three executions to perform a change impact analysis on a SQL workload. The first one collects performance data for the version of the workload before the change, the second one collects data for the version of the workload after the change, and the third one performs impact analysis. All of these executions belong to the same task and are grouped into this view. Similarly, the automatic SQL tuning task, SYS_AUTO_SQL_TUNING_TASK, creates a new execution for each tuning run.
Related View
USER_ADVISOR_EXECUTIONS displays metadata information for task executions 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 |
|
|
|
|
Execution ID |
|
|
|
User-supplied description of the task |
|
|
|
|
Type of the last execution (optional for single-execution tasks) |
|
|
|
|
Reserved for internal use |
|
|
|
|
Execution start date and time |
|
|
|
|
|
Last modified date and time for the execution |
|
|
|
Execution end date and time |
|
|
|
|
Advisor associated with the task |
|
|
|
|
The degree of parallelism (DOP) value requested by the user (through the |
|
|
|
|
The actual degree of parallelism (DOP) with which the execution finished. If the requested DOP is greater than than what is available on the system, the |
|
|
|
|
Indicates whether concurrency was used for this execution ( |
|
|
|
|
|
Unique identifier for the advisor |
|
|
|
Current operational status of the task:
|
|
|
|
|
|
Reserved for internal use |
|
|
|
Informational message provided by the advisor regarding the status |
|
|
|
|
Informational message or an error message indicating the current operation or condition |
See Also:
“USER_ADVISOR_EXECUTIONS”
