Re: DBMS_AQ.LISTEN

From: shridned <shrniad_at_yahoo.com>
Date: Fri, 15 Nov 2002 17:03:57 +0100
Message-ID: <ar35lr$jnf$04$1@news.t-online.com>

are your serious ?

your software were desupported years ago ??

upgrade to at least 8.1.7.4 or open a museum

"Michael" <migurd_at_hotmail.com> schrieb im Newsbeitrag news:de318913.0211150608.7de90f72_at_posting.google.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
Received on Fri Nov 15 2002 - 10:03:57 CST