Run SQL*Loader for 1G into tables

From: Daniele Ronci <ronci_at_bigfoot.com>
Date: Tue, 14 Jul 1998 11:00:33 +0200
Message-ID: <35AB1E31.20376365_at_bigfoot.com>

Dear Readers,
i have just insert in Oracle 1G of data using SQL*Loader and multiprocessor computers.
The struct of file is very simplex (record is fixed long) and the option direct=true is set.
This are the time:

                                  elapsed time      cpu time

Siemens RM1000       2:56:56.78        3:13.86

Alpha Server 8400     1:58:02.94          46.63

With the option parallel=true and four SQL*Loader instance (4G of data) without index the time are:

                                  elapsed time      cpu time

Siemens RM1000       1:40:57.56        2:57.59

Alpha Server 8400       40:53.42            44.75

Please, if somebody have perform a similary test, can send me your result for comparation.
Thank's and bye !!!

Daniele Ronci
ronci_at_bigfoot.com
Siemens Nixdorf
Rome, Italy Received on Tue Jul 14 1998 - 11:00:33 CEST