Re: Performance problem

Your problem could be dynamic space management. If all the allocated extents are used up (for the first 150,000 rows), your insert would issue recursice SQLs to allocate more extents to the table. If this is the problem, you can handle it easily. Before trying your insert again, do the following :

1. Estimate the amount of space needed for 600,000 rows.
2. Manually allocate the space required as the next extent (using ALTER TABLE allocate extent). Make sure you have enough space in your tablespace. If not, depending on the version of ORACLE you are running you have different options to handle this. You may add a new datafile or resize the existing datafile.

If you do your insert now, you should be OK. You may want to do a similar 'ALTER INDEX ... ALLOCATE EXTENT' command for the index also.

Though there are other factors to check, since you are saying you looked into them, this solution should help. Still ensure that your datafiles for the table and index are on different disk drives.

Good luck,
CM

In article <6gv7am$7dn$1_at_peuplier.wanadoo.fr>,   "Aldo Calzolari" <Aldo.calzolari_at_hol.fr> wrote:
>
> I have to insert 600,000 rows into a table. There is no problem for the
> first 150,000 rows and after the import procedure becomes slow, VERY slow
> (at the beginning, 100 rows are processed in approx. 20 s, after 150,000, 1
> row requires 4 sec.).
>
> I have no problem at all with my indexes and my datafiles, I've checked
> everything and all seems normal.
>
> Any help would be appreciated,
> thank you
>
> Aldo Calzolari,
> Net Valley, Paris, FR
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Apr 14 1998 - 12:25:18 CDT