The automatic statistic collection is enabled. However, when check it last run on 12-Dec-2021.
Auto Statistics Collection is enabled:
I used this query to check the last run:
select * from dba_scheduler_job_log
where additional_info like '%GATHER_STATS_PROG%'
order by log_date desc;
LOG_ID LOG_DATE OWNER JOB_NAME
------- -------------------------------------- -------- ---------------------- ...
357690 12-DEC-21 12.33.18.148607000 PM -05:00 SYS ORA$AT_OS_OPT_SY_26821 ...
...
Please advise what should I need to look at and how to fix it.
Thank you,
Warren
] 
Blog
Search
Help
Members
Register
Login
Home
