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
Advertisements

Tagged: , , , ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: