Partition Last Analyzed Date Is Incorrect and Statistics is not Gathered
(Doc ID 2233092.1)
Last updated on DECEMBER 11, 2019
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A 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