Tag Archives: LONGP_POLICY

ADR Purging

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