Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: sqlldr performance
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
![]() |
![]() |