Partition Last Analyzed Date Is Incorrect and Statistics is not Gathered
(Doc ID 2233092.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
- A monthly manual job executed on 08-Jan-2017 to gather stats on the newest partition partition "PERF_2016", but the LAST_ANALYZED date on the partition lists 08-Dec-2016 instead
- This causes 'bad' execution plans gives poor performance sql
- Error 'TIMED OUT' is shown from dba_optstat_operations
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document