Oracle-L: Queue_message wait event

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Wed, 12 Mar 2003 09:24:07 -0800
Message-ID: <F001.00567C0F.20030312092407@fatcity.com>

Hi all,

Does anyone know how to tackle this one? Developers are complaining that (it appears) the de-queuing is slow.

DB is 9202
aq_tm_processes = 5
job_queue_processes = 4
_job_queue_interval = 3

SQL> select * from gv$aq where qid in (44673,42358);

QID WAITING READY EXPIRED TOTAL_WAIT AVERAGE_WAIT ---------- ---------- ---------- ---------- ---------- ------------

     42358          0          1          0          0            0
     44673          0         11          0       1321   146.777778

The average_wait column ... is it micro|centi|mega seconds?? Also how to investigate the de-queuing problems? I couldn't find a single hit on queue_message event on metalink, even an advance search.

Thanks in advance for your help
Raj

Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: Rajendra.Jamadagni_at_espn.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).



text/plain attachment: ESPN_Disclaimer.txt

Received on Wed Mar 12 2003 - 11:24:07 CST