| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: how do I interpret this in bstat/estat
Tim,
Thanks a lot. This does help. The data that I have are a result from a test run, so I can't do anything right now, but this does give me something to look at if I see the enqueue timeouts increasing in the database in the future.
thank you
Gene
--- Tim Gorman <tim_at_sagelogix.com> wrote:
> Gene,
>
> This is the problem with high-level aggregate
> reports like
> BSTAT/ESTAT and STATSPACK. A possible problem is
> highlighted, but there is no detail on the possible
> cause.
>
> One way to get more info is monitor V$SESSION_EVENT
> view
> searching for sessions with lots of waits on
> "enqueue"
> wait-event:
>
> select sid, time_waited
> from v$session_event
> where event_name = 'enqueue'
> order by 2 desc;
>
> When you find an active session that seems to fit,
> then find
> out more about it, and most especially slap a
> "level-8" SQL
> trace on the session for a period of time. Also,
> get more
> information from V$SESSION to understand what
> program is
> running, etc...
>
> Very often, you find out that the situation is
> benign, for
> example:
>
> * a single session is responsible for all enqueue
> timeouts; this session simply waits on a
> DBMS_PIPE for messages, but the sending
> application is not sending any messages, thus
> waiting application racks up lots of
> timeouts...
>
> Hope this helps...
>
> -Tim
>
>
> > Hi.
> >
> > I am looking at the bstat/estat report and see a
> high
> > number of enqueue timeouts in the statistics
> section
> > of the report. How do I tackle that? In the
> Niemec's
> > book he receoomends increasing the
> enqueue_resources
> > parameter. Metalink says that these may be related
> to
> > DISTRIBUTED_LOCK_TIMEOUT being exceeded in a
> > distributed transaction. Comments about changing
> > ENQUEUE_RESOURCES are ill-founded. But it doesn't
> make
> > any recommendations.
> > So my question is whether anyone has any practical
> > suggestions what I can do to address this issue. I
> am
> > running Oracle 9203 (yes, I should be usuns the
> > statspack, but I haven't switched to it yet).
> >
> > TIA
> >
> > Gene
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! Hotjobs: Enter the "Signing Bonus"
> Sweepstakes
> > http://hotjobs.sweepstakes.yahoo.com/signingbonus
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net --
> > Author: Gurelei
> > INET: gurelei_at_yahoo.com
> >
> > Fat City Network Services -- 858-538-5051
> > http://www.fatcity.com San Diego, California
> --
> > Mailing list and web hosting services
> >
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: gurelei_at_yahoo.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Jan 20 2004 - 16:29:36 CST
 |
 |