sqlldr performance

From: Nan <nandagopalj_at_hotmail.com>
Date: 17 Oct 2001 11:40:11 -0700
Message-ID: <8193246.0110171040.3b1664cb@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:40:11 CDT