From oracle-l-bounce@freelists.org Mon Mar 22 08:24:58 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2MEOwd18335 for ; Mon, 22 Mar 2004 08:24:58 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2MEOvo18330 for ; Mon, 22 Mar 2004 08:24:57 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 28723390D28; Mon, 22 Mar 2004 09:21:47 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 15062-66; Mon, 22 Mar 2004 09:21:47 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 715CC390D4A; Mon, 22 Mar 2004 09:21:46 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 22 Mar 2004 09:20:40 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F3EFA390C4D for ; Mon, 22 Mar 2004 09:20:39 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 15123-43 for ; Mon, 22 Mar 2004 09:20:39 -0500 (EST) Received: from smtp21.singnet.com.sg (smtp21.singnet.com.sg [165.21.101.201]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8150A390C0C for ; Mon, 22 Mar 2004 09:20:38 -0500 (EST) Received: from hemant.singnet.com.sg (bb220-255-87-54.singnet.com.sg [220.255.87.54]) by smtp21.singnet.com.sg (8.12.11/8.12.11) with ESMTP id i2MERNtA026579 for ; Mon, 22 Mar 2004 22:27:23 +0800 Message-Id: <5.1.1.6.0.20040322222408.00ac8228@pop.singnet.com.sg> X-Sender: hkchital@pop.singnet.com.sg X-Mailer: QUALCOMM Windows Eudora Version 5.1.1 Date: Mon, 22 Mar 2004 22:25:43 +0800 To: oracle-l@freelists.org From: Hemant K Chitale Subject: Re: Advanced queues : aq_tm_processes In-Reply-To: Mime-Version: 1.0 Content-Type: text/html; charset="us-ascii" X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 1388 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: hkchital@singnet.com.sg Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org
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 -----------------------------------------------------------------