Re: sqlldr performance

I actually have say for e.g. 1000 datafiles with control information and data.
Each file has about 100,000 row in it. Further assume all the datafiles are
for a particular table. If I run multiple copies of sqlldr one per data file I hope to get better performance. Since all the sqlldr load data into the same table, will there be contention issues?

Thanks,
Nan.

"Howard J. Rogers" <howardjr_at_www.com> wrote in message news:<3bce7d4f$1_at_news.iprimus.com.au>...
> 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 - 10:09:37 CDT