SQL*Loader question about ROWS option
From: vk02720 <vk02720_at_my-deja.com>
Date: 30 May 2002 12:16:10 -0700
Message-ID: <4d814faa.0205301116.3dfaace1_at_posting.google.com>
Date: 30 May 2002 12:16:10 -0700
Message-ID: <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 Thu May 30 2002 - 21:16:10 CEST