Re: Long term AWR retention
Date: Wed, 30 Jun 2010 09:35:26 +0300
Message-id: <4C2AE5AE.10608_at_inter.net.il>
I can think of two reasons:
1) Cost affective. The overhead, in DBA time, to create this, is not worth the cost of running a monthly report to detect trends. 2) The Grid is your repository.
Adar Yechiel
Rechovot, Israel
Mark W. Farnham wrote:
>
> Lots of good insights and responses in this thread. But I have a question:
>
>
>
> Why do so few people copy database metric data to a non-production
> machine? (And AWR is just a start.)
>
>
>
> Shouldn't every DBA and/or DBA team have a DBA's data warehouse? Why
> use production cpu cycles to analyze anything but real time or near
> real time concerns?
>
>
>
> Why wonder about year-over-year trends when you can know? Wouldn't
> improved ability to make a capacity plan based on actual data more
> than pay for any associated costs?
>
>
>
> mwf
>
> ------------------------------------------------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] *On Behalf Of *Carol Dacko
> *Sent:* Friday, June 25, 2010 5:10 PM
> *To:* mark.teehan_at_credit-suisse.com
> *Cc:* oracle-l_at_freelists.org
> *Subject:* Re: Long term AWR retention
>
>
>
> 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_at_credit-suisse.com <mailto:mark.teehan_at_credit-suisse.com>>
> 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
> ==============================================================================
>
>
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 30 2010 - 01:35:26 CDT