Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Statspack and Enqueue wait times
Richard Foote wrote:
> "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
Looking for a good source I can point my students to with respect to tracing. Something more tutorial with step-by-step than the standard otn documents.
Any suggestions will be appreciated.
-- Daniel Morgan http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Wed Jun 25 2003 - 11:34:38 CDT