Re: AQ

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).
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Stephen Andert
> INET: StephenAndert_at_firsthealth.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: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

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