Re: Oracle Dequeue one record for every 6 second.

From: Tanel Poder <tanel_at_remove.this.peldik.com>
Date: Tue, 4 Feb 2003 07:35:47 +0100
Message-ID: <3e3f5166_2@news.estpak.ee>

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
>
Received on Tue Feb 04 2003 - 00:35:47 CST