I would think that the relationship would be similar to that between the
number of jobs and the number
of job_queue_processes.
If your jobs or queue processes are not due to run concurrently, then you
do not need additional
job_queue_processes / aq_tm_processes.
The number of processes would help you achieve parallelism if you need
parallelism.
Hemant
At 01:48 AM Monday, you wrote:
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 !
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com {last updated 21-March-04}
"If you wish to leave your footprints on the sand, do not drag your feet"
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@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 Mon Mar 22 2004 - 08:24:58 CST