Re: FOR UPDATE WAIT

From: VC <boston103_at_hotmail.com>
Date: Thu, 10 Nov 2005 20:30:29 -0500
Message-ID: <j6-dnSSqPcOtae7enZ2dnUVZ_tadnZ2d@comcast.com>

Hi,

<sstetsen_at_gmail.com> wrote in message
news:1131638454.222570.192790_at_g44g2000cwa.googlegroups.com...
> Yes, we all know this way to emulate FOR UPDATE WAIT.
> Just to emulate, because using i.e. FOR UPDATE WAIT 5
> a) we are PERMANENTLY trying to lock a resource up to 5 secs and
> b) we get "ORA-30006: resource busy; acquire with WAIT timeot expired"
> after 5 secs with no success.
>
> The (a) is the most important point because your solution cannot
> resolve
> the situation WAIT 5 = SLEEP(5) when we try to lock with no success
> and go to sleep for 5 seconds. During this time the resource could be
> released
> and locked again many times. But we are sleeping...
>
> No?
>

What problem are you trying to solve ? Apparently, the tool (SFU) is not suitable for the task, maybe it makes sense to look elsewhere... Received on Thu Nov 10 2005 - 19:30:29 CST