Message-ID: <01f401c3e996$9e0b1b00$111de818@sun>
From: "Diego Cutrone" <diegocutrone@yahoo.com.ar>
To: <oracle-l@freelists.org>
References: <F001.005DDAE8.20040120142936@fatcity.com>
Subject: Re: how do I interpret this in bstat/estat
Date: Mon, 2 Feb 2004 11:12:38 -0300
MIME-Version: 1.0
Content-type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Sender: oracle-l-bounce@freelists.org
Errors-To: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: oracle-l@freelists.org

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


----- Original Message ----- 
From: "Gurelei" <gurelei@yahoo.com>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L@fatcity.com>
Sent: Tuesday, January 20, 2004 7:29 PM
Subject: 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@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@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@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@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@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@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@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.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------