SYSAUX Statistics History Tables are Still Growing Even After Application of Patch 14373728
(Doc ID 1528085.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
<Patch 14373728> contains improvements to daily automatic stats history purging. After <Patch 14373728> was applied, the AWR statistics history tables are still growing.
Query on the tables indicate that the tables have already been converted to partitioned tables.
At the time the following query was executed, some of the partitions are older than the retention period (which was 30 days) :
With <Patch 14373728> applied. It is expected that partitions would be automatically purged when all the data within them exceed the retention period.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!