SYSAUX Statistics History Tables are Still Growing Even After Application of Patch 14373728 (Doc ID 1528085.1)

Last updated on MAY 19, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.

Symptoms

<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.

 

 

Changes

 None

Cause

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