Re: Load slowing down?
Date: Thu, 29 Nov 2001 14:16:54 GMT
Message-ID: <qrrN7.572$726.120180_at_news1.sttln1.wa.home.com>
My guess is that the table it is going into has its high water mark set high
and the process that inserts the data into the table uses a full table scan.
Post an explain plan of the insert.
Jim
"andrija" <ar35644_at_fer.hr> wrote in message
news:9u50mv$amnu$1_at_as201.hinet.hr...
> I have script for loading ASCII file into database.
> First I use SQL loader to load data into temporary tables. After that I
> start procedure which does some linking of loaded data which is nessesary.
> After that I move data from temp tables to main tables.
>
> There are 7 main tables, two of them have 30,000,000 rows. Tablespace has
20
> Gb, and it is localy managed.
>
> Problem is, that few days ago load of one ASCII file with 10,000 rows took
> 10 seconds to finish, but now it takes 90 seconds. Problem is not SQL
> loader, but procedure for linking and coping. But why it is so slow now?
>
> Nothing is changed, we started a large load (some 6000 ASCII files). When
we
> started it was fast (10 sec/file), now it's slow (90 sec/file).
>
> Anyone can help?
>
>
Received on Thu Nov 29 2001 - 15:16:54 CET