Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Locking Strategy
"edmond" <edmond_at_hotmail.com> wrote in message
news:42c4c090$1_1_at_rain.i-cable.com...
> Just want to know if it is good practice to use SELECT FOR UPDATE without
> NOWAIT in my program. I am worrying if some misbehaved sessions get
> timeout'ed while locking some critical table, my whole application would
> potentially be brought down. However, if NOWAIT is used, I have to
manually
> handle the EXCEPTION for failure to obtain the lock and retry until some
> predetermined timeout period. This seems to be too much work if every
> SELECT FOR UPDATE statement requires such logic.
>
> Appreciate if anyone could share their experience. Thx a lot.
>
>
What business problem are you trying to solve?
Jim
Received on Fri Jul 01 2005 - 00:06:45 CDT