Path: news.easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: manish_kohli@infy.com (First Logic)
Newsgroups: comp.databases.oracle.misc
Subject: Dequeue or Delete in AQ
Date: 6 Jun 2002 03:56:26 -0700
Organization: http://groups.google.com/
Lines: 18
Message-ID: <69f75565.0206060256.40adcb14@posting.google.com>
NNTP-Posting-Host: 164.164.86.66
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1023360986 1961 127.0.0.1 (6 Jun 2002 10:56:26 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 6 Jun 2002 10:56:26 GMT
Xref: easynews comp.databases.oracle.misc:82574
X-Received-Date: Thu, 06 Jun 2002 04:54:50 MST (news.easynews.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.