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 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