Oracle 19C 列出Optimizer Statistics Advisor任务

原创 Asher.HU 2021-02-04

1266

该DBA_ADVISOR_EXECUTIONS视图列出了Optimizer Statistics Advisor任务的执行。

列出Optimizer Statistics Advisor任务：

在SQL * Plus中，以具有管理员特权的用户身份登录数据库。

查询DBA_ADVISOR_EXECUTIONS如下：

COL EXECUTION_NAME FORMAT a14

SELECT EXECUTION_NAME, EXECUTION_END, STATUS
FROM   DBA_ADVISOR_EXECUTIONS
WHERE  TASK_NAME = 'AUTO_STATS_ADVISOR_TASK'
ORDER BY 2;

以下示例输出显示了8个执行：

EXECUTION_NAME EXECUTION STATUS
-------------- --------- -----------
EXEC_1         27-AUG-16 COMPLETED
EXEC_17        28-AUG-16 COMPLETED
EXEC_42        29-AUG-16 COMPLETED
EXEC_67        30-AUG-16 COMPLETED
EXEC_92        01-SEP-16 COMPLETED
EXEC_117       02-SEP-16 COMPLETED
EXEC_142       03-SEP-16 COMPLETED
EXEC_167       04-SEP-16 COMPLETED

8 rows selected.

「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」

关注作者

Oracle 19C 列出Optimizer Statistics Advisor任务

评论