Advanced queues : aq_tm_processes
- From: "Jamadagni, Rajendra" <Rajendra.Jamadagni@xxxxxxxx>
- To: "Oracle List (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 21 Mar 2004 12:48:03 -0500
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 !
Other related posts:
