Re: Locking Strategy

edmond wrote:
> 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.

Is a truck better than a sports car?

What are the business rules?

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)