Re: sqlldr performance oracle 8.1.7

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Fri, 21 Jan 2005 20:32:01 +0100
Message-ID: <v3m2v05unjamv991oj3tomcac27bipjsge@4ax.com>

On 21 Jan 2005 03:50:30 -0800, johnleslie_at_madasafish.com (John Leslie) wrote:

>I am trying to increase the performance of sqlldr. I understand that
>one method is to disable index maintenance and the rebuild the index
>afterwards, but the index rebuild seems to take just as long as
>anytime saved during the load.
>
>Any thoughts on how the index rebuild can be speeded up?

alter index ... rebuild nologging

alter session set sort_area_size = <anything between 1 and 4 M>

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Jan 21 2005 - 13:32:01 CST