Re: Advanced queues : aq_tm_processes
- From: Jeremiah Wilton <jwilton@xxxxxxxxxxxxx>
- To: "Oracle List (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 21 Mar 2004 11:46:30 -0800 (PST)
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
-----------------------------------------------------------------
Other related posts:
