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