Re: SQL*Loader question about ROWS option

From: george lewycky <gelewyc_at_nyct.com>
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

Original text of this message