Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Dequeue or Delete in AQ

Dequeue or Delete in AQ

From: First Logic <manish_kohli_at_infy.com>
Date: 6 Jun 2002 03:56:26 -0700
Message-ID: <69f75565.0206060256.40adcb14@posting.google.com>


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:

  1. Enqueing the record with Correlation Id.
  2. Dequeuing the record in BROWSE mode.
  3. Based on some condition, "DELETE" or "DEQUEUE" the record with above correlation ID.

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US