RE: Advanced queues : aq_tm_processes
- From: "Jamadagni, Rajendra" <Rajendra.Jamadagni@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 22 Mar 2004 10:28:01 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
