Re: oracle loader

From: dias <ydias_at_hotmail.com>
Date: 14 Jul 2003 12:08:26 -0700
Message-ID: <55a68b47.0307132326.63241bf1@posting.google.com>

Hi,

As Daniel said, use Direct path loads.
I'll add in NOLOGGING mode.

Dias

oldnicholassummers_at_hotmail.com (nick summers) wrote in message news:<ba6a3b65.0307111335.7a0cdc39_at_posting.google.com>...
> 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
Received on Mon Jul 14 2003 - 14:08:26 CDT