Re: Advanced Queue Latency

droth wrote:
> 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

You certainly have an issue but it isn't AQ batching anything.

Check out the demos in Morgan's Library at www.psoug.org

I had to build a SLEEP into the procedure to keep it from completing in sub-second times.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org