RE: System statistics - How often?

  • From: "Newman, Christopher" <cjnewman@xxxxxxxxxxxxx>
  • To: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>, <andrew.kerber@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 29 Sep 2008 13:31:46 -0500

Thanks both of you.  Niall, great idea to track the changes, we'll be
testing that out for sure.  Thanks again - Chris

-----Original Message-----
From: Niall Litchfield [mailto:niall.litchfield@xxxxxxxxx] 
Sent: Monday, September 29, 2008 1:26 PM
To: andrew.kerber@xxxxxxxxx; Newman, Christopher; oracle-l@xxxxxxxxxxxxx
Subject: Re: System statistics - How often?

I too see no reason to recollect.  it does make sense to collect to a
custom stats table say hourly over a business cycle, say a month or a
week, then analyse in excel for averages and patterns.

On 29/09/2008, Andrew Kerber <andrew.kerber@xxxxxxxxx> wrote:
> Most of the documentation I have seen say to collect for an hour or so
> high usage times.  Only collect again if your usage pattern changes.
> On Mon, Sep 29, 2008 at 11:48 AM, Newman, Christopher <
> cjnewman@xxxxxxxxxxxxx> wrote:
>> Anyone have any recommendations for the collection of system
>> Any recommendation on how long to run the capture?  I've heard 72
>> before (ie, M-W during a business week, which should represent the
>> of activity, shifting the window if you have more activity on X day).
>> Is there any reason to re-gather system statistics if hardware
>> unchanged?
>> Also, when you want to ensure you can go back to old system stats, do
>> you export, or use a stats table, or some other method?
>> Thanks - Chris
>> --
> --
> Andrew W. Kerber
> 'If at first you dont succeed, dont take up skydiving.'

Niall Litchfield
Oracle DBA

Other related posts: