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