统计信息收集失败，查看对应分区是否已收集完成

1、查看统计信息收集失败信息，sys用户登录

select *
from dba_autotask_job_history
where client_name = 'auto optimizer stats collection'
and window_start_time > trunc(sysdate) - 1
and job_status <> 'SUCCEEDED'

 

2、查看分区的统计信息收集时间
select * from user_ind_statistics s
where s.INDEX_NAME in (select index_name
and s.PARTITION_NAME in ('P_698','P_668')