Oracle 视图 DBA_ADVISOR_JOURNAL 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_ADVISOR_JOURNAL提供了关于执行DB ADVISOR任务所产生的建议信息和任务结果记录，包括日志，用于了解DB ADVISOR任务的执行状况和结果。
使用此视图的步骤如下：
1、先执行一个DB ADVISOR任务：
SQL> EXEC DBMS_ADVISOR.TASK_EXECUTE(‘MyTask’,NULL,”);
2、然后查询视图以查看生成的建议：
SELECT * FROM DBA_ADVISOR_JOURNAL
WHERE task_name = ‘MyTask’;
以上步骤可以查询到任务的数据库访问和为您调用的构造例程的状况记录，以及每个ADVISOR建议的信息，如结果状况等。
官方英文解释
DBA_ADVISOR_JOURNAL displays the journal entries for all tasks in the database.
Related View
USER_ADVISOR_JOURNAL displays the journal entries for 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 or workload object |
|
|
|
Name of the task or workload object |
|
|
|
|
The name of the task execution with which this entry (row) is associated |
|
|
|
|
|
Sequence number of the journal entry (unique for each task). This sequence number is used to order the data. |
|
|
|
Type of the task:
|
|
|
|
|
Entry in the journal |
See Also:
“USER_ADVISOR_JOURNAL”
