Oracle 视图 DBA_ADVISOR_LOG 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图DBA_ADVISOR_LOG提供有关已完成或运行中的Database Advisors日志中的信息，其中包括有关每个执行的任务的详细信息，以及针对其中各项检测到的建议的信息。

使用步骤:
1. 登录到SQL*Plus系统，并连接到Oracle数据库。
2. 检查已运行的Advisors日志，可以使用SELECT语句从DBA_ADVISOR_LOG视图中检索出已存储的日志信息，如：
`SQL
SELECT * FROM DBA_ADVISOR_LOG;
`
3. 分析日志，查看Advisor报告的执行状况和检测到的潜在问题。
4. 如果有必要，可以考虑按照Advisor报告中的建议进行调整，以提高系统性能。

官方英文解释

DBA_ADVISOR_LOG displays information about the current state of all tasks in the database, as well as execution-specific data such as progress monitoring and completion status.

The view contains one row for each task.

Related View

USER_ADVISOR_LOG displays information about the current state of the tasks owned by the current user. This view does not display the OWNER column.

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

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

FATAL ERROR A fatal error occurred during the analysis operation. All recommendation data is unusable.

Metric that measures the progress of the task in terms of quality. Each advisor could 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

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

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