Re: AQ

From: Stephen Andert <StephenAndert_at_firsthealth.com>
Date: Tue, 20 Jan 2004 08:39:25 -0800
Message-ID: <F001.005DDA92.20040120083925@fatcity.com>

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

Received on Tue Jan 20 2004 - 10:39:25 CST