SYSAUX Statistics History Tables are Still Growing Even After Application of Patch 14373728
Last updated on MAY 19, 2017
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms