Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Dequeue or Delete in AQ
Hi,
We are working on oracle 8.1.7.2.
I want to know whether it is advisable to "dequeue" or "delete" a
required from the queue table (FROM PL/SQL).
Following is the flow of our requirement:
Does Delete gives any problem (locking etc.)? Does performace of enqueing or dequeuing goes down over a period of time?
Thanks,
First Logic.
Received on Thu Jun 06 2002 - 05:56:26 CDT