Aldo Calzolari 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
It may be that the first 150,000 rows or so are simply filling up the
db_buffers in the SGA. Once the SGA db_buffers are filled, the
database writer (DBWR) will begin writing those buffers to disk. If
the database writer can't keep up with the inserts, there will be
some degradation. If you only have one DBWR running, you might
consider starting another one and see what happens.
--
Kelly Young
Database Administrator
Maricopa Community Colleges
young_at_maricopa.edu
Received on Tue Apr 14 1998 - 09:56:59 CDT
