Re: Statspack

From: Ed Stevens <nospam_at_noway.nohow>
Date: Wed, 28 Apr 2004 13:10:01 -0500
Message-ID: <djsv8054dciiaofd83dt1k0203l1ao7p25@4ax.com>

On Wed, 28 Apr 2004 15:36:59 +0100, "Mill" <mill.h_at_ntlworld.com> wrote:

>Have just run statspack on a oracle 8.1.7.4 DB on windows 2k with 2gb RAM,
>can anybody see
>anything in the results i need to be concerned about ?
>
>Appreciate any comments/tips
>
>
>STATSPACK report for
>
>DB Name DB Id Instance Inst Num Release OPS Host
>------------ ----------- ------------ -------- ----------- --- ------------
>IFSL 3136346323 ifsl 1 8.1.7.4.1 NO ORACLE1
>
> Snap Id Snap Time Sessions
> ------- ------------------ --------
> Begin Snap: 39 28-Apr-04 13:45:06 61
> End Snap: 40 28-Apr-04 14:49:01 61
> Elapsed: 63.92 (mins)
>
>Cache Sizes

<snip>

Look at your top 5 wait events. These *are* your top 5 wait events and represent the low-hanging fruit for any tuning effort. Whether or not they represent an actual problem, only you can say.

I always feed my statspack reports thru Oraperf (http://www.oraperf.com/) for some additional analysis and suggestions. You might try that. Received on Wed Apr 28 2004 - 13:10:01 CDT