Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Statspack and Enqueue wait times

Re: Statspack and Enqueue wait times

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Wed, 25 Jun 2003 09:34:38 -0700
Message-ID: <3EF9CF1E.AF8E4E1D@exxesolutions.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US