自动任务-优化器统计信息收集-日志

Question

我已经通过Cloud Control中的"Automated Maintenance Tasks“设置了Optimizer Statistics Gathering。自动任务作业是否有日志来查看它收集了哪些对象的统计信息？

通过检查dba_tables by date，我可以列出收集统计数据的表。

Answer 1

数据字典视图DBA_OPTSTAT_OPERATIONS和DBA_OPTSTAT_OPERATION_TASKS提供优化器统计信息收集操作的摘要和详细信息。

--Optimizer statistics gathering.
select *
from dba_optstat_operations
order by start_time desc;

--Optimizer statistics gathering details.
select *
from dba_optstat_operation_tasks
order by start_time desc;