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: 422
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 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
|
|
|
|
Goto Forum:
Current Time: Sun May 04 19:48:17 CDT 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
