| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: SQLLDR performance?
A copy of this was sent to Greg Gershowitz <gregg_at_computex.com>
(if that email address didn't require changing)
On Fri, 29 Jan 1999 12:50:48 -0500, you wrote:
>
>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
use direct=y if you can (read about the direct path mode of the loader).
also, do you see lots of "checkpoint not complete, cannot allocate new log" in your alert*.log file? If so, you need more log to handle the load and the load will go faster....
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Fri Jan 29 1999 - 12:13:06 CST
 |
 |