Re: System statistics - How often?

  • From: "Allan Nelson" <anelson77388@xxxxxxxxx>
  • To: cjnewman@xxxxxxxxxxxxx
  • Date: Wed, 1 Oct 2008 07:51:38 -0500

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

Other related posts: