EM 12c: AWR Warehouse Retention Set To One Year, but Older Snapshots are being Retained by Enterprise Manager 12c Cloud Control
(Doc ID 2231582.1)
Last updated on SEPTEMBER 01, 2021
Applies to:
Enterprise Manager for Oracle Database - Version 12.1.0.2.0 to 12.1.0.8.0 [Release 12.1]Information in this document applies to any platform.
Symptoms
Navigate: Targets > Databases > Performance Menu > AWR Warehouse
The page shows the Oldest column is older than one year.
However, the dest_retention_period_yrs value from the repository database is one year as shown by this query:
SQL> select PROPERTY_VALUE from dbsnmp.caw_properties
where property_name='dest_retention_period_yrs'
PROPERTY_VALUE
--------------------------------------------------------------------------------
1
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 |
| Cause |
| Solution |
| References |