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: Oracle Dequeue one record for every 6 second.

Re: Oracle Dequeue one record for every 6 second.

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Mon, 03 Feb 2003 23:13:41 -0800
Message-ID: <3E3F6825.C2526756@exesolutions.com>


Tanel Poder wrote:

> Hi!
>
> He's working with AQ.
>
> Check the bug 2298215 from metalink.. Oracle has a patch backport for
> 8.1.6.3.0 I believe. But as Daniel suggested, upgrade to newer version of
> database, that way you'll fix a lot of issues.
>
> Tanel.
>
> "DA Morgan" <damorgan_at_exesolutions.com> wrote in message
> news:3E3F33DB.4CF2B52_at_exesolutions.com...
> > chan01 wrote:
> >
> > > i configure a queue, when i dequeue the data it's taking 6 seconds for
> > > each recored. i have only number and varchar2 fields. i am curious is
> > > there any parameter to do this. i am using 816 on Sun Solaris 5.8.
> > >
> > > Thanks.
> >
> > What do you mean by "configure a queue"?
> > What do you mean by "when I dequeue"?
> > Why are you using 8.1.6 when it is unsupported and has been obsolete for
> > years?
> > Solaris 5.8 on what platform? Intel or Sun?
> > Given your antique Oracle ... are your O/S patches current?
> >
> > Nothing in Oracle can take 6 seconds per record so I suspect you are
> > looking in the wrong place. But without clarifications ... can't say for
> > sure.
> >
> > Daniel Morgan
> >

I assumed that but then again ... assumptions often lead to incorrect advice. Advice to upgrade is correct whether it is an AQ issue or other.

Daniel Morgan Received on Tue Feb 04 2003 - 01:13:41 CST

Original text of this message

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