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.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Owner of the task |
|
|
|
|
|
Identifier of the task |
|
|
|
Name of the task |
|
|
|
|
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 could 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 |
See Also:
“USER_ADVISOR_LOG”
