Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Advanced queues : aq_tm_processes

RE: Advanced queues : aq_tm_processes

From: <oracle-l-bounce_at_freelists.org>
Date: Mon, 22 Mar 2004 10:56:21 -0500
Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CFECFC54@bosmail00.bos.il.pqe>


Raj,

According to Cary's paper available at HotSos, you want no more than 2 concurrent jobs per batch queue. See "Batch Queue Management and the Power of 2" on the HotSos site for more info.

-----Original Message-----
From: Jamadagni, Rajendra [mailto:Rajendra.Jamadagni_at_espn.com] Sent: Monday, March 22, 2004 10:28 AM
To: oracle-l_at_freelists.org
Subject: RE: Advanced queues : aq_tm_processes

So, in our case we might have to change them dynamically as we enqueue/dequeue at much faster rates from 12noon to about 5am (various game times all across USA) and it is very small during rest of the day.

I was trying to find/establish a relationship if one should exist. I don't want 5 aq_tm_processe locking each other out all the time.

Thanks
Raj

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jeremiah Wilton Sent: Sunday, March 21, 2004 2:47 PM
To: Oracle List (E-mail)
Subject: Re: Advanced queues : aq_tm_processes

Depending on the rate of enqueue/dequeue, one should be enough. Multiple QMN processes compete with each other and chew up tons of CPU and memory.

As with all parallel operations, just experiment with defferent degrees of parallelism.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Sun, 21 Mar 2004, Jamadagni, Rajendra wrote:


> 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:)
---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 Mon Mar 22 2004 - 09:55:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US