Thanks, Tanel.
Sorry, if I caused any confusion.
May be I should have used 'pipe get' event instead of 'SQL*Net message from client' as an example,
which of course, should not be ignored in a multi-tier, networked environment. In fact, I remove
it, among a few others, from PERFSTAT.STAT$IDLE_EVENT table, when & if, I use Statspack..
Cheers!
- Kirti
- Tanel Poder <tanel.poder.003_at_mail.ee> wrote:
> Hi!
>
> I think what Kirti meant here, is that from only database's point of view
> (scope), the "SQL*Net message from client" waits do not indicate any
> database bottlenecks.
>
> Anyway, when you have network bottleneck, from my experience you usually see
> other SQL*Net message waits, like "more data to/from client" etc as well.
>
> Tanel.
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, January 20, 2004 6:39 PM
>
>
> > However...
> >
> > do not blindly treat SQL*Net messages as Idle waits. They can be
> > important indicators of networking issues.
> >
> > Stephen
> >
> > >>> kirtikumar_deshpande_at_yahoo.com 01/20/04 08:24AM >>>
> > It is defined as below in the Reference Guide:
> >
> > "The session is waiting on an empty OLTP queue (Advanced Queuing) for a
> > message to arrive so that
> > the session can dequeue that message."
> >
> >
> > I would treat it as an Idle Wait, similar to, SQL*Net message from
> > client.
> >
> > - Kirti
> >
> > --- "Ehresmann, David" <David.Ehresmann_at_ps.net> wrote:
> > >
> > > Is "queue message" an idle or an non-idle wait event? I have looked
> > through
> > > the docs at tahti and metalink and can't find much info on AQ. Does
> > anybody
> > > know where there are resources on this topic?
> > >
> > > thanks,
> > >
> > > David Ehresmann
> > >
> > > --
> > >
> >
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: Kirtikumar Deshpande
INET: kirtikumar_deshpande_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 Wed Jan 21 2004 - 07:54:27 CST