ADR Purging

Oracle April 22, 2011 Leave a comment

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: , , , ,

Leave a Reply

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

Gravatar
WordPress.com Logo

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

Google photo

You are commenting using your Google 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 )

Cancel

Connecting to %s

%d bloggers like this: