Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Advanced queues : aq_tm_processes
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 !