Re: Oracle Dequeue one record for every 6 second.

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Mon, 03 Feb 2003 19:30:35 -0800
Message-ID: <3E3F33DB.4CF2B52@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 Mon Feb 03 2003 - 21:30:35 CST