Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Dequeue one record for every 6 second.
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