Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Lock detection and resolution
nsouto_at_nsw.bigpond.net.au.nospam (Nuno Souto) wrote in message news:<3b0e66a4.17676970_at_news-server>...
> On 25 May 2001 06:18:20 -0700, onlyforposting_at_yahoo.com (Vikas
> Agnihotri) wrote:
>
> >
> >'select for update nowait' places a row-exclusive lock on the row,
> >right? How can the session release this lock? Only by doing a
> >commit/rollback? This is too drastic. Is there any other way?
>
> There is, but it is undocumented and you should not rely on it.
> Financials used it, IIRC. Dunno if still does.
Nuno, could you tell me what that undocumented way to do it, just for my curiosity?
Yong Huang
yong321_at_yahoo.com
Received on Mon May 28 2001 - 00:05:01 CDT