Home » RDBMS Server » Enterprise Manager » Automatic Statistics Collection (Oracle Database 19c Enterprise Edition Release 19.0.0.0.0)
Automatic Statistics Collection [message #686814] Thu, 12 January 2023 14:44
wtolentino
Messages: 364
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:
/forum/fa/14679/0/

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

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


Current Time: Thu Feb 09 03:33:21 CST 2023