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