Advanced queues : aq_tm

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Sun, 21 Mar 2004 12:48:03 -0500
Message-ID: <A186CBDC8B1D61438BC50F1A77E91F735B6947@xchgbrsm1.corp.espn.pvt>

Hi all,

Should aq_tm_processes be dependent on # of queues defined in the system? Is there a relation between # of queues and # of aq_tm_processes? Are they bound one to one?

I am asking because on one of the databases, I have 8 non sys/system queues and aq_tm_processes=5. I was checking current sql run by all qmn (qmn0-4) processes and they were all working on the same queue and executing same sql ...

<sql>
select q_name, state, delay, expiration, rowid, msgid,

       dequeue_msgid, chain_no, local_order_no, enq_time,
       enq_tid, step_no,   priority, exception_qschema,
       exception_queue, retry_count, corrid,
       time_manager_info, sender_name,
       sender_address, sender_protocol

from schema.XXX_QTAB
where time_manager_info <= :1 and state != :2 for update skip locked </sql>

Is this normal? Maybe I was expecting that aq processes will be working on different queues ... 8:) Raj

Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. select standard_disclaimer from company_requirements; QOTD: Any clod can have facts, having an opinion is an art !

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_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


-----------------------------------------------------------------

Received on Sun Mar 21 2004 - 11:45:30 CST

Advanced queues : aq_tm_processes