Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sqlldr performance

Re: sqlldr performance

From: Nan <nandagopalj_at_hotmail.com>
Date: 18 Oct 2001 08:04:53 -0700
Message-ID: <8193246.0110180704.6e00f239@posting.google.com>


May I know the basis of your inference?
Thanks
Nan.

"Jos" <wolters401_at_zonnet.nl> wrote in message news:<Frkz7.792$c3.3873_at_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 Thu Oct 18 2001 - 10:04:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US