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
-----------------------------------------------------------------