Oracle 视图 DBA_ADVISOR_TASKS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_ADVISOR_TASKS存储系统中所有 Advisor 任务的状态和行为信息。它保存了所有配置在数据库中的advisor任务，包括已经执行和未执行的任务，以及它们用于执行任务的任务参数。此外，DBA_ADVISOR_TASKS视图还存储有关最近一次Advisor 任务完成状态的信息，还有每次完成任务的消耗时间，有关负责执行此Advisor任务的用户的信息，以及Advisor任务完成后产生的结果数据。
此外，DBA_ADVISOR_TASKS视图还允许DBA用户查询所有Advisor任务，而不必手动搜索每个实例。它可以帮助DBA用户查找所有配置的Advisor任务，并检查任务的状态，例如已创建但未执行，已完成或未完成。
使用 Oracle DBA_ADVISOR_TASKS 视图的一般步骤如下：
1. 查询 DBA_ADVISOR_TASKS 视图以查看当前配置的 Advisor 任务：
`SELECT * FROM DBA_ADVISOR_TASKS;`
2. 如果需要，可以基于某个特定的任务进行修改：
`UPDATE DBA_ADVISOR_TASKS SET PARAMETER1 = ;`
3. 通过重新执行 DBMS_ADVISOR 包中的 execute 方法执行：
`EXEC DBMS_ADVISOR.EXECUTE(TASK_NAME);`
官方英文解释
DBA_ADVISOR_TASKS displays information about all tasks in the database.
The view contains one row for each task. Each task has a name that is unique to the owner. Task names are just informational and no uniqueness is enforced within any other namespace.
Related View
USER_ADVISOR_TASKS displays information about the tasks owned by the current user. 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 |
See Also:
“USER_ADVISOR_TASKS”
