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 |
|
|
|
|
|
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: