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:
- TRACE
- CDUMP
- UTSCDMP
- IPS
2. LONGP_POLICY (Default is 8760 hours or 365 days). LONGP_POLICY is used for the following:
- ALERT
- INCIDENT
- SWEEP
- STAGE
- HM
Tagged: ADR, adrci, LONGP_POLICY, SHORTP_POLICY, UTSCDMP
Leave a Reply