Daily aggregated metric data is not cleared as per retention policy (Doc ID 2532234.1)

Last updated on FEBRUARY 19, 2020

Applies to:

Symptoms

After reducing retention policy for "Daily aggregated metric data"(Table: EM_METRIC_VALUES_DAILY_E), data is not purged as per retention policy.

For instance, when the default retention policy for "Daily aggregated metric data" is changed from 24 months to 3 months, we can see the records for more than 3 months in table EM_METRIC_VALUES_DAILY_E.

Example:
Below query is giving some records which are not expected. Here retention policy changed to 3 months but we can data for more than 4 months as per below SQL.
select count(*) from EM_METRIC_VALUES_DAILY where collection_time < trunc(add_months(sysdate, -4))

Cause

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