Re: Uncommited insert blocks update?

Could you clarify this slightly -

Are you saying that an update statement from one session attempting to update
a row inserted but not yet committed
by another session appeared to hang
waiting for the commit/rollback ?

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Lothar Armbüster wrote in message
<924.86T521T12442960lothar.armbruester_at_rheingau.netsurf.de>...
>Hello out there,
>
>today I observed some strange behaviour of our Oracle 8.1.5 database on
>NT.
>We had a long running insert blocking updates on the same table.
>That means the update seemed to wait for a lock but when i selected
>the rows which should be updated there were nothing. Obviously the update
>statement waited for the insert to complete in order to change the newly
>inserted rows (or some of them). I expected that rows that cannot be seen
>by a select would not be affected in an update.
>Is the observed behaviour a bug or a feature of Oracle?
>
>I could imagine some use of such a behaviour when trying to update unique
>columns which are inserted but not commited yes but I want to know if this
>is the desired behaviour or if it is just a bug.
>
>Any ideas?
>
>Lothar
>
>--
>Lothar Armbrüster | lothar.armbruester_at_rheingau.netsurf.de
>Hauptstr. 26 | lothar.armbruester_at_t-online.de
>D-65346 Eltville |
>
Received on Mon Feb 21 2000 - 14:39:50 CST