Performance sqlldr (direct path) on 9.2.0.3

From: Heiko Welter <heiko.welter_at_t-mobile.de>
Date: 17 Apr 2003 00:13:34 -0700
Message-ID: <5b9217b5.0304162313.2322dfb4@posting.google.com>

Hi!

Testing sqlldr on 9.2.0.3 (32-Bit) and 8.1.7.2 we found out, that the CPU-Time used for the load "exploded":

8.1.7.2 Elapsed time was: 00:00:15.18 CPU time was: 00:00:00.52
9.2.0.3 (almost no load on that machine!) Elapsed time was: 00:00:08.01 CPU time was: 00:00:05.07

While testing sqlldr on 9.2.0.3 (64-Bit) with a larger File (1 GB) the used CPU-Time increased 300%. Times are taken from the Loader-Logfile.

Has anyone made similar experience? Is this really true, or did they only change the way they measure the CPU-Usage? Is that a reasonable relationship between elapsed time and cpu-time?

Thanks for your ideas/suggestions!

cheers
Heiko Received on Thu Apr 17 2003 - 02:13:34 CDT