Home » RDBMS Server » Enterprise Manager » Automatic Statistics Collection (Oracle Database 19c Enterprise Edition Release
Automatic Statistics Collection [message #686814] Thu, 12 January 2023 14:44
Messages: 404
Registered: March 2005
Senior Member
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 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,

Previous Topic: OEM CC 13R2 gui language
Next Topic: Oracle Enterprise Manager Agent 13.1 Windows install
Goto Forum:

Current Time: Wed May 29 01:25:18 CDT 2024