My Oracle Support Banner

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

Last updated on NOVEMBER 07, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.