Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQLLDR performance?
I'm use sqlldr to reload some data. I think it's taking too long (around 4 hours for 1,000,000 rows). I've tried upping the bindsize, so it's commiting around 65 rows at a time. How much higher can I push this value? I'm running Oracle 8.0.4 on an Ultra 5 w/512 MB RAM and Solaris 2.6.1.
Here's the command I'm using right now: sqlldr userid=$DBADMINID/$DBADMINPW control=$TMP_DIR/$ptablename.octl log=$TMP_DIR/$ptablename.log bad=$TMP_DIR/$ptablename.bad rows=10000 bindsize=1048576 > $OUTFILE
Thanks
-Greg G Received on Fri Jan 29 1999 - 11:50:48 CST