Re: Record locking in Oracle

I do not think that the init.ora parameter distributed_lock_timeout applies to your situation, because we use it to time-out distributed connections which basically are SQL statements issued on one instance of Oracle that access tables stored on another instance of Oracle via a database link.

If I issue an update against a row that another session of Oracle has updated but not committed my session will wait as long as necessary for the other session to commit. There is a parameter that can be added to some SQL statements, nowait, that will return upon encountering a locked row. I am not an expert in its use, but you should be able to research it or to post with a subject like 'How to use nowait?'.

I hope this helps some.

Mahantesh Nashi <mahan_at_mobinfo.com> wrote in article <3630B9BD.4AE5FA23_at_mobinfo.com>...
> Hi everybody,
>
> We want to know if there is any equivalent of 'SET LOCK MODE TO <no of
> seconds>' statement in Oracle. The SET LOCK .. statement is available in
> Informix. It allows the user to specify num ber of seconds to wait to
> acquire the lock. If the process couldn't get the lock in the specified
> time, then the server gives an error. User can trap this error and
> proceed to do whatever he wants to do.
>
> We have Oracle workgroup server. When we contacted Oracle, they said
> there is no such feature in Oracle work group server. However there is a
> way in Oracle Enterprise server by using 'DISTRIBUTED_LOCK_TIMEOUT'.
>
> Could anybody clarify this?
>
> Thanks,
> Mahathesh
>
>
>
Received on Mon Oct 26 1998 - 13:08:01 CST