VC wrote:
> Daniel:
>
> "Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
> news:1073278668.569595_at_yasure...
>
>>VC wrote:
>>
>>>Daniel,
>>>
>>>Yes, you are quite right regarding the 'SKIP LOCKED' modifier.
>>>
>>>However, the SKIP LOCKED has several potential issues:
>>>
>>>1. it's undocumented;
>>>2. it's not supported by Oracle for anything besides AQ;
>>>3. it was designed to be used for Advanced Queueing only;
>>>
>>>Rgds.
>>>
>>>VC
>>
>>You are correct on all points.
>>
>>Any comments with respect to the use of NOWAIT?
>
>
> Well, SELECT FOR UPDATE with the NOWAIT modifier will not cause a dead-lock
> at the expence of more complex application logic.
>
> VC
Thanks.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Mon Jan 05 2004 - 10:17:12 CST
