| Oracle® Database Reference 11g Release 1 (11.1) Part Number B28320-01 |
|
|
View PDF |
| Oracle® Database Reference 11g Release 1 (11.1) Part Number B28320-01 |
|
|
View PDF |
DBA_ADVISOR_EXECUTIONS displays metadata information for task executions. For example, the SQL Replay Advisor 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.
Related View
USER_ADVISOR_EXECUTIONS displays metadata information for task executions owned by the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(30) |
Owner of the task | |
TASK_ID |
NUMBER |
NOT NULL |
Unique identifier of the task |
TASK_NAME |
VARCHAR2(30) |
Name of the task | |
EXECUTION_NAME |
VARCHAR2(30) |
NOT NULL |
The name of the task execution with which this entry (row) is associated |
DESCRIPTION |
VARCHAR2(256) |
User-supplied description of the task | |
EXECUTION_TYPE |
VARCHAR2(30) |
Type of the last execution. This information is optional for single-execution tasks. | |
EXECUTION_TYPE# |
NUMBER |
??? | |
EXECUTION_START |
DATE |
Execution start date and time of the task | |
EXECUTION_LAST_MODIFIED |
DATE |
NOT NULL |
Date on which the task was last modified |
EXECUTION_END |
DATE |
Execution end date and time of the task | |
ADVISOR_NAME |
VARCHAR2(30) |
Advisor associated with the task | |
ADVISOR_ID |
NUMBER |
NOT NULL |
Unique identifier for the advisor |
STATUS |
VARCHAR2(11) |
Current operational status of the task | |
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 |
