Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_AQ.LISTEN

Re: DBMS_AQ.LISTEN

From: chan01 <chandra_2000_us_at_yahoo.com>
Date: 15 Nov 2002 16:07:22 -0800
Message-ID: <480cb9d4.0211151607.25424584@posting.google.com>


"shridned" <shrniad_at_yahoo.com> wrote in message news:<ar35lr$jnf$04$1_at_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

Are you sure it should not take that much time to see in the dequeue. i am using the AQ's they were pretty fast. I am using Sun E3500, Solaris 8, Oracle 8.1.6. Received on Fri Nov 15 2002 - 18:07:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US