advanced queue latency

From: droth <droth_at_uptodate.com>
Date: 27 Jul 2006 10:56:37 -0700
Message-ID: <1154022997.411296.119430@m73g2000cwd.googlegroups.com>

Advanced Queue Latency

Oracle 10.1.0 on LINUX
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 - 12:56:37 CDT