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.

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

Type of the last execution. This information is optional for single-execution tasks.

INTERRUPTED Task analysis was interrupted by the user. Recommendation data, if present, can be viewed and reported at this time.

COMPLETED Task successfully completed the analysis operation. Recommendation data can be viewed and reported.

ERROR An error occurred during the analysis operation. Recommendations, if present, can be viewed and reported at this time.

Metric that measures the progress of the task in terms of quality. Each advisor may have its own metric.

Counter that is updated frequently by the advisor, denoting that useful work is being performed

Informational message or an error message indicating the current operation or condition

Indicates whether the task is a system task (TRUE) or not (FALSE). The automatic SQL tuning task, SYS_AUTO_SQL_TUNING_TASK, is one example of a system task.

我想要获取技术服务或软件
服务范围：MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式：远程服务、电话支持、现场服务，沟通指定方式服务
技术标签：数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题

本站部分文章参考或来源于网络，如有侵权请联系站长。
数据库远程运维 Oracle 视图 DBA_ADVISOR_TASKS 官方解释，作用，如何使用详细说明