Re: oracle loader

nick summers wrote:

> I cannot find any data that indicates throughput for oracle loader as
> a baseline. We are loading 20,000,000 lines (intending to do so
> daily.... ;-)
> It currently takes approx 12 hours - but I have worked at sites that
> have achieved the same level of throughput on similar servers (solaris
> 2.8 oracle 9i and gs80 compaq alpha servers) in far less time.
>
> Any guidelines would be much appreciated
>
> oldnicholassummers_at_hotmail.com

Are you doing direct path loads? Were they?

20M inserts taking 12 hours is outrageous. I'd be looking at metrics on hardware I/O and waits.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)