Re: sqlldr performance

From: Jos <wolters401_at_zonnet.nl>
Date: Wed, 17 Oct 2001 20:51:38 +0200
Message-ID: <Frkz7.792$c3.3873@zonnet-reader-1>

Your local dba is right

A remote DBA

"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 Wed Oct 17 2001 - 13:51:38 CDT