dbms_aq.listen

From: mri <member_at_dbforums.com>
Date: Wed, 20 Nov 2002 11:50:37 +0000
Message-ID: <2067362.1037793037@dbforums.com>

Hi,

I'm doing some investigations in order to find how to implement asynchronous transactions in my database. My examples work fine: I can start up a procedure which is listening "forever", and this is able to retrive my enqueued messages and dequeue them.

But there is one essential problem left: When I enqueue a message it takes between 1 and 10 seconds before the message is caught by dbms_listen and dequeued.

Can I manipulate this "feature" in order to have my messages processed somewhat quicker, or do I have another problem. And why this somewhat arbitrary delay?

The db is 8.1.5 running on IBM AIX

/Michael

--
Posted via http://dbforums.com

Received on Wed Nov 20 2002 - 05:50:37 CST