Check out running SQL Loader in parallel -it can be done, and if you
distribute the temporary files it creates amongst sufficient devices, you
should get performance improvements (though "running it in parallel" is a
bit of a misnomer... you basically copy your control file X times and chop
the datafile up into X pieces, and fire up X number of sql loader sessions).
Regards
HJR
--
Resources for OracleT: www.geocities.com/howardjr2000
=========================================
"Nan" <nandagopalj_at_hotmail.com> wrote in message
news:8193246.0110171040.3b1664cb_at_posting.google.com...
> Hello:
>
> I have a need to load about 20 million records in to 30 different tables.
> I am using sqlldr oracle utility to do this.
>
> My question is: To improve performance I plan on using multiple copies
> of sqlldr in a concurrent fashion. I am not sure of the impacts when
> multiple concurrent copies of sqlldr utility loads data into the same
> given table.
> I was told by the local DBA that it is not a very good approach.
> I am not fully convinced that it is a bad approach.
> I would appreciate your feedback on the same.
>
> Thanks,
> Nan.
Received on Thu Oct 18 2001 - 02:06:39 CDT
