Re: SQL*Loader on steroids

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 1 Apr 2007 15:37:48 +0100
Message-ID: <b92dnVu3ra-qWZLbnZ2dnUVZ8sqjnZ2d@bt.com>

"Ramon F Herrera" <ramon_at_conexus.net> wrote in message news:1175402262.372261.179850_at_d57g2000hsg.googlegroups.com...
>
> Where I need help is in another aspect: how else can I make SQL*Loader
> run faster? I seem to recall some (parallel?, direct?) mode of
> loading. Is there a substantial performance difference between fixed
> record length and delimited (the latter is what I currently use)?
>
> TIA,
>
> -Ramon F Herrera
>

In earlier versions of Oracle, I have seen a significant difference in CPU usage when using fixed length fields rather than delimited - even to the extent that writing a C program to convert delimited to fixed and then loading was quicker than letting SQL*Load examine the file looking for delimiters and using generic conversion routines.

It may not be true in 10g - but it's worth a test if the volumes are large.

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Received on Sun Apr 01 2007 - 09:37:48 CDT