We have a situation where during peak times (usually closing the ERP) we lease extra CPUs. This can be a reason to rerun system stats. Allan > > -----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 > >> > >> -- > >> //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 > -- > //www.freelists.org/webpage/oracle-l > > >