When tuning the performance of Oracle SQL loader (sqlldr), the read size and bind size option are very critical. When ociuldr utility generate the SQL loader control file for you, the default read size and bind size are fixed 8MB. Sometime it's not big enough.
OPTIONS(BINDSIZE=8388608,READSIZE=8388608,ERRORS=-1,ROWS=50000)
LOAD DATA
......
So I add a new command line option "BUFFER" to specify the read size and bind size, and the default value is changed to 16MB (minimum value 8MB, maximum value 100MB) now. We just need to specify the size in MB, for example.
ociuldr user=... query=... talbe=... BUFFER=10
And the generated SQL loader control file will look like as following.
OPTIONS(BINDSIZE=10485760,READSIZE=10485760,ERRORS=-1,ROWS=50000)
LOAD DATA
......
You can test the performance change with different buffer values.