| 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
Gene,
If you see your enqueue waits are significant in v$system_event, then you
may have an enqueue wait problem in your instance.
Then you can also check sys.x$ksqst (enqueue statistics) and get a
classification of enqueue waits.
You can also set up a realtime procedure that takes a 10046 dump (or just
check v$session_wait) of the sessions that are suffering enqueue waits to
get a more detailed information.
Regards,
Diego Cutrone
> 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
> > >
> >
> ----------------------------------------------------------
> > > ----------- 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).
>
>
> __________________________________
> 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).
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Mon Feb 02 2004 - 08:12:38 CST
 |
 |