Advanced Queue Latency

From: droth <droth_at_uptodate.com>
Date: 27 Jul 2006 10:57:20 -0700
Message-ID: <1154023040.569140.219180_at_75g2000cwc.googlegroups.com>



Advanced Queue Latency

Oracle 10.1.0 on LINUX
[Quoted] Using DBMS_AQ.

I am trying to send messages from instance ORCLA to instance ORCLB on another machine.
I am experiencing a delay of about 20 seconds between the enqueue time and the dequeue time.
Latency is set to zero in the enqueue.
I have a daemon listening for messages.
I have tried changeing the hidden _job_queue_interval from 5 seconds to 1 second with no effect.

I read someplace that AQ batches messages. Is this true? Can batching be controlled?

What else can I do to reduce latency?

Thanks

Dave R Received on Thu Jul 27 2006 - 19:57:20 CEST

Original text of this message