4.13 DBA_ADDM_TASKS
DBA_ADDM_TASKS
displays information about all ADDM tasks in the database.
The view contains one row for each row in the related DBA_ADVISOR_TASKS
view that has ADVISOR_NAME=ADDM
and STATUS=COMPLETED
.
Related View
USER_ADDM_TASKS
displays information about the ADDM tasks owned by the current user. The view contains one row for each row in the related USER_ADVISOR_TASKS
view that has ADVISOR_NAME=ADDM
and STATUS=COMPLETED
. This view does not display the OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the task |
|
|
|
Unique identifier of the task |
|
|
|
Name of the task |
|
|
|
User-supplied description of the task |
|
|
|
Advisor associated with the task |
|
|
|
Creation date of the task |
|
|
|
Date on which the task was last modified |
|
|
|
Identifier of the parent task (if the task was created because of the recommendation of another task) |
|
|
|
Identifier of the recommendation within the parent task that resulted in the creation of the task |
|
|
|
Name of the current or last task execution |
|
|
|
Type of the last execution. This information is optional for single-execution tasks. |
|
|
|
Reserved for internal use |
|
|
|
Optional description of the last execution |
|
|
|
Execution start date and time of the task |
|
|
|
Execution end date and time of the task |
|
|
|
Current operational status of the task:
|
|
|
|
Informational message provided by the advisor, regarding the status |
|
|
|
Percent completion, in terms of time, of the task when it is executing |
|
|
|
Metric that measures the progress of the task in terms of quality. Each advisor may have its own metric. |
|
|
|
Unit of the metric used to measure progress |
|
|
|
Counter that is updated frequently by the advisor, denoting that useful work is being performed |
|
|
|
Number of recommendations produced |
|
|
|
Informational message or an error message indicating the current operation or condition |
|
|
|
Optional name that identifies the creator of the task |
|
|
|
Optional task or template on which the object was based |
|
|
|
Indicates whether the task is read-only ( |
|
|
|
Indicates whether the task is a system task ( |
|
|
|
Unique identifier for the advisor |
|
|
|
Reserved for internal use |
|
|
|
The database ID that the task was using |
|
|
|
The name of the database that the task was analyzing |
|
|
|
The version of the database that the task was analyzing |
|
|
|
The version of the database that executed the task |
|
|
|
The snapshot ID that starts the analysis period |
|
|
|
The |
|
|
|
The snapshot ID that ends the analysis period |
|
|
|
The |
|
|
|
The type of ADDM analysis that was requested before task execution, as follows:
|
|
|
|
The type of ADDM analysis that was actually performed when the task was executed (either |
|
|
|
The total database time accumulated in the analysis period (and analyzed instances) in microseconds |
|
|
|
The average active sessions during the analysis period (and analyzed sessions) |
|
|
|
Reserved for future use |
|
|
|
The number of findings for the ADDM task, which will appear in the list of findings in a default ADDM report |
|
|
|
Indicates the open mode of the database that the task was analyzing, as detected by ADDM. Possible values:
|
|
|
|
Indicates the assumed open mode of the database that the task was analyzing. If the value of this column is different from the value of the
|
|
|
|
Indicates the type of database that the task was analyzing, as detected by ADDM. Possible values:
|
|
|
|
Indicates the assumed type of database that the task was analyzing. If the value of this column is different from the value of the
|
Footnote 1 This column is available starting with Oracle Database release 19c, version 19.1. If the task was analyzing a database at a release earlier than Oracle Database 19c, and that database was subsequently upgraded to Oracle Database 19c, then the value of this column is NULL.
See Also: