Re: deadlocks between single update statements ?

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 25 Sep 2006 14:19:02 -0700
Message-ID: <1159219143.40541@bubbleator.drizzle.com>

hasta_l3_at_hotmail.com wrote:
> DA Morgan wrote :
>

>> My error. I meant to suggest SELECT FOR UPDATE NOWAIT.

>
> Why NOWAIT, BTW ?
>
> A transaction with
> - a select for update correctly ordered
> - followed by an update of the same rows
>
> should do the trick, isn't it ?

Provided another session hasn't already locked one or more records desired by the user.

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group

Received on Mon Sep 25 2006 - 16:19:02 CDT