Re: FW: 10g sqlldr and PARALLELism

You either lack something, or have coordination issues. Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok) ===

Upcoming appearances:

• Jan 27, 2005: London, UKOUG Unix SIG: Data Guard Best Practices
• Feb 9-10, 2005: Denver, RMOUG Training Days: Data Guard Performance Issues
• Mar 6-10, 2005: Dallas, Hotsos Symposium: Data Guard Performance Issues On Wed, 2005-01-19 at 22:38, Levesque, Roger wrote:

> I am running Oracle 10g on an IBM P690 with AIX. For a particular job I
> load 8GB using sqlldr, direct=yes in two hours. I wanted to speed this
> up, so I broke the job up into four jobs, each loading 2GB each with the
> parallel=true option turned on. These four jobs now take six hours
> each. Why is there a time increase?
>
>
>
> I can't find a parameter that will solve the apparent contention that is
> going on.
>
>
>
> Any ideas where I may be going wrong?
>
>
>
> Thanks ... Roger
>
>
>
>
>
>
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the sender by email, delete and destroy this message and its
> attachments.
>
> **********************************************************************
>
>
> --
> http://www.freelists.org/webpage/oracle-l

            
      * 

--
http://www.freelists.org/webpage/oracle-l