Re: SQL*Loader question about ROWS option
Date: 31 May 2002 09:36:55 -0700
Message-ID: <68aecc05.0205310836.7ca28e75_at_posting.google.com>
according to Oreilly's Oracle SQL*Loader book p. 170
the syntax is :
sqlldr user/pass control= bindsize=500000
will give you bindsize of 500000 bytes
the default is 64KB or 256KB in 9i
for nt & unix bindsize limit is same as readsize limit !!
good luck
George Lewycky
> How to increase the size of the bind array for better performance ?
> I increased the rows to 100 using ROWS=100 on sqlldr command line but
> the log still says 31 rows as follows:
>
> Bind array: 100 rows, maximum of 65536 bytes
> ....
> ....
>
> Space allocated for bind array: 63984 bytes(31 rows)
> Space allocated for memory besides bind array: 0 bytes
>
> Total logical records skipped: 0
> Total logical records read: 103328
> Total logical records rejected: 0
> Total logical records discarded: 0
>
> TIA
Received on Fri May 31 2002 - 18:36:55 CEST