Re: System statistics - How often?
Date: Mon, 29 Sep 2008 19:26:09 +0100
Message-ID: <7765c8970809291126v4ab2bb9bt10a370af77f4797c@mail.gmail.com>
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-lReceived on Mon Sep 29 2008 - 13:26:09 CDT