Re: Statspack and Enqueue wait times

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 26 Jun 2003 00:22:20 +1000
Message-ID: <mWhKa.1178$p8.44122@newsfeeds.bigpond.com>

"Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:DQhKa.1174$p8.42588_at_newsfeeds.bigpond.com...
> "Brian Peasland" <oracle_dba_at_remove_spam.peasland.com> wrote in message
> news:3EF89A3F.4E206DC7_at_remove_spam.peasland.com...
> > If your sessions are waiting on the Enqueue event, then they are waiting
> > for locks to be released before they can continue. So you'll have to
> > revisit the application and see if you can reduce the lock contention.
> >
>
> That or possibly depending on how your applications load and subsequently
> manipulate data, you may have insufficient transaction slots due to your
> initrans settings.
>
> You don't use bitmap indexes by any chance ....
>

Ooops, forgot to mention try tracing an affected session (10046 level 8/12 event) and suz out what specifically it's waiting on ...

Richard Received on Wed Jun 25 2003 - 09:22:20 CDT