Re: Row Locking

Paul Berger (pberger_at_nic.wat.hookup.net) wrote:
> We have done some testing within SQL*Plus to force a lock
> state on a single row within a table accessed by two concurrent
> users. The blocked user becomes "locked" indefinitely until
> the "blocker" either commits or roles back their transaction.
> Oracle on behalf of the blocked user does nothing. Is there
> some way, at the session or system level, that we can bias
> Oracle's behaviour in this regard? Can we establish a time-out
> so that the blocked user can proceed in an informed fashion,
> rather than waiting on the "blocker" to do something?

select ... for update of ... nowait

--
**************************************************************
*                          Saad Ahmad                        *
*                          McHugh Freeman & Associates, Inc. *
*                          Ph:  (414) 798-8606 Ext. 457      *
*                          Fax: (414) 798-8619               *
*                          E-Mail: sahmad_at_mfa.com            *
**************************************************************