DBA_ADVISOR_EXECUTIONS

4.19 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`	`VARCHAR2(128)`		Owner of the task
`TASK_ID`	`NUMBER`	`NOT NULL`	Unique identifier of the task
`TASK_NAME`	`VARCHAR2(128)`		Name of the task
`EXECUTION_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the task execution with which this entry (row) is associated
`EXECUTION_ID`	`NUMBER`	`NOT NULL`	Execution ID
`DESCRIPTION`	`VARCHAR2(256)`		User-supplied description of the task
`EXECUTION_TYPE`	`VARCHAR2(128)`		Type of the last execution (optional for single-execution tasks)
`EXECUTION_TYPE#`	`NUMBER`		Reserved for internal use
`EXECUTION_START`	`DATE`		Execution start date and time
`EXECUTION_LAST_MODIFIED`	`DATE`	`NOT NULL`	Last modified date and time for the execution
`EXECUTION_END`	`DATE`		Execution end date and time
`ADVISOR_NAME`	`VARCHAR2(128)`		Advisor associated with the task
`REQUESTED_DOP`	`NUMBER`		The degree of parallelism (DOP) value requested by the user (through the `TEST_EXECUTE_DOP` parameter). It can be any value greater or equal to zero.
`ACTUAL_DOP`	`NUMBER`		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 `ACTUAL_DOP` value can be lower than the `REQUESTED_DOP` value.
`CONCURRENT_EXECUTION`	`VARCHAR2(3)`		Indicates whether concurrency was used for this execution (`YES`) or not (`NO`)
`ADVISOR_ID`	`NUMBER`	`NOT NULL`	Unique identifier for the advisor
`STATUS`	`VARCHAR2(11)`		Current operational status of the task: `EXECUTING` `COMPLETED` `INTERRUPTED` `CANCELLED` `FATAL ERROR`
`STATUS#`	`NUMBER`	`NOT NULL`	Reserved for internal use
`STATUS_MESSAGE`	`VARCHAR2(4000)`		Informational message provided by the advisor regarding the status
`ERROR_MESSAGE`	`VARCHAR2(4000)`		Informational message or an error message indicating the current operation or condition