Re: SQL*Loader question about ROWS option

In your case, 31 rows = 63984 bytes. 100 rows would = 206400. Your bindsize needs to be increased, either in the control file or on command line.
See the following:
http://info-it.umsystem.edu/oradocs/doc/server/doc/SUT73/ch5a.htm#bind%20arr%20size

But note the following: "Although the entire bind array need not be in contiguous memory, the buffer for each field in the bind array must occupy contiguous memory. If the operating system cannot supply enough contiguous memory to store a field, SQL*Loader generates an error." Got big fields?

~ALE vk02720_at_my-deja.com (vk02720) wrote in message news:<4d814faa.0205301116.3dfaace1_at_posting.google.com>...
> 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:05:39 CEST