Oracle11g has introduced a lot of very good features. It is very important to understand the default purging policies s of these features. I will discuss ADR purging policies in the blog. The defaults are sufficient for most databases. You can change the defaults using ADRCI.
ADR Purging Policy
ADR has 2 types of policies. Both the policies are specified in hours.
1. SHORTP_POLICY (Default is 720 hour or 30 days). SHORTP_POLICY is used for the following:
2. LONGP_POLICY (Default is 8760 hours or 365 days). LONGP_POLICY is used for the following: