Re: Slowness on insert statemente

From: mario <xnazsco_at_tiscali.it>
Date: Tue, 17 Aug 2004 09:18:37 +0200
Message-ID: <pan.2004.08.17.07.18.31.533976@tiscali.it>

Il Fri, 13 Aug 2004 05:33:06 -0700, Pete's ha scritto:

> "mario" <xnazsco_at_tiscali.it> wrote in message news:<pan.2004.08.12.08.20.00.26204_at_tiscali.it>...

>> Hi all,
>> a simple question:
>> the dimension of a table can directly be responsible
>> of the slowness of an insertion?
>> in other words: if I have two identical tables that only
>> differ for the number of records, it is the insert of one record
>> slower in the big table regarding the small?
>> 
>> thank's

>
> The table that is experiencing the slow insert, have there been many
> deletes on this table? You may be getting some free list contention.
> Also, how many indexes on this table are there vs. the one that
> inserts fast? If you have many indexes on many different columns,
> then this will slow the insert down as Oracle will have to insert the
> data into all the indexes.
>
> HTH,
> Pete's
                                

Hi,
the two databases are identical except for the number of records. The smallest in fact, has been created from a cold backup of the largest one deleting some million of records in order to run some tests faster. The physical path of the datafiles are not the same, but I think that this is not a problem, because the datafiles are on a netapp filer and are mounted via NFS in both the db.

cheers
M.                                                                  Received on Tue Aug 17 2004 - 02:18:37 CDT