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_at_gmail.com] Sent: Monday, September 29, 2008 1:26 PM To: andrew.kerber_at_gmail.com; Newman, Christopher; oracle-l_at_freelists.org 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_at_gmail.com> 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_at_uillinois.edu> 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