RE: System statistics - How often?

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
at
> 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
statistics?
>> Any recommendation on how long to run the capture?  I've heard 72
hours
>> before (ie, M-W during a business week, which should represent the
bulk
>> of activity, shifting the window if you have more activity on X day).
>>
>> Is there any reason to re-gather system statistics if hardware
remains
>> 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
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>


-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l


Other related posts: