Re: SQL*loader: loading 4 tables parallel?

Carsten,

Direct path would be the best option

Carsten Jacobs wrote:
>
> Hallo,
> I have to load data into 4 tables.
> I'm using a shell script which sequentially starts the SQL*Loader four
> times.
>
> Then I changed the script in a way that it starts each loader process in
> the backgroud
> so that they are running parallel.
>
> My intention was of course to speed up the load. But the performance
> isn't much better than the sequential load.
> Each loader process now needs more time.
> I guess it is because all tables are on the same tablespace and all the
> processes have to share the resources (controller).
>
> I don't use direct path load because Oracle resides on NT and the
> SQL*Loader is startet on Linux.
>
> Can I expect a faster load if the tables are on different tablespaces on
> different harddisk?
> Is there anything else to do to gain perfomance?
>
> Thanks for any help or suggestion
>
> Carsten
Received on Fri Oct 20 2000 - 18:14:45 CEST