Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Effective deadlock handling
Galen Boyer wrote:
> On Sat, 03 Jan 2004, damorgan_at_x.washington.edu wrote:
>
>>Galen Boyer wrote: >> >>>Thanks for ignoring everything else. >> >>I agreed with you. I thought that was obvious from my statement >>"Exactly".
As I understand it the wait with a SELECT FOR UPDATE is not a deadlock but rather an intentional wait. With a slight change in syntax ... SKIP ... that doesn't happen.
To my way of thinking this is not a deadlock as it generates no error condition.
Did I misunderstand you?
-- 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 Sat Jan 03 2004 - 20:15:19 CST