Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: A row locking problem that baffles all...

Re: A row locking problem that baffles all...

From: Paul <aspscott_at_tcp.co.uk>
Date: Sat, 16 Jan 1999 00:08:13 GMT
Message-ID: <36a0d684.1190923@news.tcp.co.uk>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US