SQL*Loader, bind array, and commit

From: Jeremy Buckley <jbuckley_at_btg.com>
Date: 1997/11/08
Message-ID: <3463f0df.12324521@news.btg.com>#1/1

I'm loading a table using SQL*Loader, and I'd like to get it to commit every 1000 rows or so. On the command line, I specify ROWS=1000 and BINDSIZE=512000. In the log file, I see ...

Bind array: 1000 rows, maximum of 512000 bytes

... and ...

Space allocated for bind array:                511896 bytes(831 rows)

Space allocated for memory besides bind array: 651504 bytes

... yet the output I get looks like ...

 SQL*Loader: Release 7.3.2.2.0 - Production on Fri Nov 7 23:33:05 1997

     Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.

     Commit point reached - logical record count 115
     Commit point reached - logical record count 230
     Commit point reached - logical record count 345
     Commit point reached - logical record count 460
     ... 

So it's committing every 115 rows, when it looks like it should be every 831 rows.

Any ideas how I can get it to commit less often?

TIA, email cc appreciated. Received on Sat Nov 08 1997 - 00:00:00 CST