My Oracle Support Banner

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

Last updated on FEBRUARY 19, 2020

Applies to:

Enterprise Manager Base Platform - Version and later
Information in this document applies to any platform.


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.

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


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

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