Re: need help on statspack report, Parse CPU to Parse Elapsd %

From: VC <boston103_at_hotmail.com>
Date: Sat, 06 Mar 2004 22:03:45 GMT
Message-ID: <5Vr2c.129345$4o.167986@attbi_s52>

Hello,

"DJ" <nospamplease_at_goaway.com> wrote in message news:Bqr2c.19602$6Z.15431_at_newsfe1-win...
>
> > 1. High enqueue wait time. The usual cause is that several sessions
are
> > trying to lock the same row (SELECT FOR UPDATE probably?) and the
average
> > wait time is 3 seconds per enqueue. Other reasons may be bitmap indexes
> > update/unindexed foreign keys/lack of ITL slots, in the order of
> decreasing
> > probability.
> >

This one (3 seconds) per enqueue is clearly abnormal. Would not you agree ?

> > 3. The percentage of rollbacks is quite high: 7.24%

As a roll back is an expensive operation, this one should be taken care of too whatever the 'normal' baseline performance is.

VC Received on Sat Mar 06 2004 - 16:03:45 CST