Re: how do I interpret this in bstat/estat

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
> ----------------------------------------------------------
> ----------- 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Gorman
  INET: tim_at_sagelogix.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).