Re: oracle loader

From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Mon, 14 Jul 2003 10:27:49 +0200
Message-ID: <1058171202.567679@news.thyssen.com>

"nick summers" <oldnicholassummers_at_hotmail.com> schrieb im Newsbeitrag 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

Hi Nick,

an addition to Daniel's posting:
referential integrity constraints enabled? Indexes in place?

Greetings,
Guido Received on Mon Jul 14 2003 - 03:27:49 CDT