Re: Long term AWR retention
- From: Carol Dacko <dackoc@xxxxxxxxx>
- To: mark.teehan@xxxxxxxxxxxxxxxxx
- Date: Fri, 25 Jun 2010 17:10:19 -0400
Mark,
We use 6 month retention with 15 minute snapshots. No problems! It has
been very helpful to have the history available to us.
Carol Dacko
University of Michigan
On Thu, Jun 24, 2010 at 10:24 PM, Teehan, Mark <
mark.teehan@xxxxxxxxxxxxxxxxx> wrote:
> I am considering increasing AWR retention from the default 7 days to a
> longer period; possibly 60 days. A longer cycle fits in better with systems
> that have monthly reporting cycles. Apart from increased space use in
> sysaux, leading to longer full backup times; I cannot think of any
> other negative effects. All AWR base tables are range partitioned; and I
> trust that all queries accessing them are configured to partition prune
> properly.
>
> I cannot find any evidence in MOS or the interwebs that this could be a bad
> thing to do: has anyone been burned by this before?
>
> Thanks!
> Mark Teehan
> Singapore
>
>
> ==============================================================================
> Please access the attached hyperlink for an important electronic
> communications disclaimer:
> http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
>
> ==============================================================================
>
>
Other related posts:
