Re: What is more costly ?

From: Matthias Kleinicke <Matthias.Kleinicke_at_gmx.de>
Date: Mon, 29 Aug 2005 08:44:49 +0200
Message-ID: <deuaan$mqn$1@online.de>

DA Morgan schrieb:
> LineVoltageHalogen wrote:
>

>> So if I have a process by which thousands of records/min are being
>> inserted into a table no other writers or readers would be blocked?  I
>> am not talking about the rows being inserted and have not been
>> committed.  I am talking about the rest of the table with its existing
>> data.

>
>
> Correct. It is impossible for an uncommited insert in Oracle to block
> anything.

there should be no real block, but in 8i an existing unique index could spoil a lot. imho this is caused by the unique-check which is bound to check even against uncommitted inserts. I have not checked in 9i or 10g for this.

greetings

Matthihas Received on Mon Aug 29 2005 - 01:44:49 CDT