Re: System statistics - How often?

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

--
http://www.freelists.org/webpage/oracle-l