Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: How to speedup sqlldr

Re: How to speedup sqlldr

From: Roman Starek <starek_at_pluto.spsselib.hiedu.cz>
Date: 2 Oct 2000 12:11:32 GMT
Message-ID: <8r9u1k$o8r$1@crax.cesnet.cz>

Johan den Boer <jj.den.boer_at_hccnet.nl> wrote:
: Hi,
 

: I have to load about 400 files into a database. Some files are
: really big. The default for sqlldr is to commit every 64 records.
: Is there a way to change this behaviour in say 256 or 1024 record ?
 

: regards

Try to read here

SQL*Loader Control File Reference

article : Determining the Size of the Bind Array

or use params BINDSIZE or ROWS

        Starous Received on Mon Oct 02 2000 - 07:11:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US