Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: A row locking problem that baffles all...
On 15 Jan 1999 19:37:44 GMT, "conan" <conan(no spam)@as-if.com> wrote:
>try to update the same record this time with the wait option specified.
>Your session will hang. open a new session. Then query the v$wait view
>which you can link back to get the session that holds the lock you are
>requesting.
You mean do a "...nowait" which if it fails do a "for update"
(excluding nowait) prehaps in a another session, find the waiter then
kill the "for update" session. Now, that sounds like an ingenious
idea. All I'm wondering is what happens if the locker commits during
the short time of the "for update". I suppose kill the "for update"
session anyway and rerun the "nowait" again in the original session!
>
>I hope that helps
Yes, going to try that, good idea.
>
>Conan
Paul
aspscott_at_tcp.co.uk
^^ remove 'as' anti spam prefix to reply
Received on Fri Jan 15 1999 - 18:08:13 CST