Oracle 视图 DBA_ADDM_TASKS 官方解释，作用，如何使用详细说明
本站中文解释
)
Oracle视图DBA_ADDM_TASKS提供了一个统一查询结果，用以查询深入分析任务（ADDM）的相关信息。DBA_ADDM_TASKS包含了深入分析任务执行在特定时间和结果的汇总信息。
可以使用这个视图去查询ADDM任务执行的记录，如深入分析任务的标识符(TASK_ID)，任务的分析时间(ANALYSIS_TIME)，实例的ID(INSTANCE_ID)，以及任务的优先级(PRIORITY)等。
可以使用下面的查询来获取深入分析任务的标识符:
SELECT TASK_ID
FROM 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:
“USER_ADDM_TASKS”
