Re: Poor SQL Loader performance

Hi,

Are you using sqlldr parallel option ? If not use it to improve performance.

HTH
Venkat

Terry Engelstad wrote:
>
> One possibility is that your database is not sized properly prior to loading
> your tables. If Oracle has to constantly expand, then it will take a long
> time. Second, how much of your 384MB RAM is Oracle using. It sounds like
> your not getting enough.
>
> Aaron Kushner wrote in message ...
> >
> >I am using SQL*Loader to populate a datawarehouse and am surprised
> >by what slow times I am getting on the loads.
> >
> >System: HP K460 with two 180Mhz processors 384MB RAM
> >Software: Oracle 7.3.2.2 HP-UX 10.20
> >Config: The index, temp, and the datafile are on separate drives
> >
> >I am using direct path load and unrecoverable option
> >
> >What would reasonable times be for the number of rows/sec?
> >Also, the loads get progressively slower. I assume the degredation
> >is due to the index since the loads take constant time when I disable
> >the primary key. Rebuilding the index takes more than 70 minutes, so
> >disabling the index on loads is not really an option.
> >
> >Thanks for any help with this problem
> >Aaron Kushner
> >akushner_at_cup.hp.com
> >
> >Times from the SQL*Loader logs:
Received on Tue May 19 1998 - 15:22:56 CDT