Re: Oracle Dequeue one record for every 6 second.

Hi,
I configure this Q with Correlated data (ex: A and B ), i am facing this problem with only the correlated data A, but B is doing fine. we put the print statements before and after the dequeue and measure the time.  

I am using Sun Solaris 5.8 on Sun E3500.

Thanks.

DA Morgan <damorgan_at_exesolutions.com> wrote in message news:<3E3F6825.C2526756_at_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 - 06:11:44 CST