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