Re: Statspack and Enqueue wait times

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 26 Jun 2003 00:16:13 +1000
Message-ID: <DQhKa.1174$p8.42588@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 ....

Cheers

Richard Received on Wed Jun 25 2003 - 09:16:13 CDT