Re: Sql loader taking too long!

From: Juan Cachito Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Fri, 20 Feb 2004 16:00:14 -0400
Message-ID: <000701c3f7ec$28956dd0$2501a8c0@dazasoftware.com>

This is very strange
even if you have 300 columns in a table, 3 hours is too much for 7,000 rows Conventional insert should take you about 30 minutes exaggerating un less you have 300 blob column with the british encyclopedy in every one.

You could check foreing constraings referencing this table. But I think you have other problem, why don't you capture a trace of the 7,000 rows (enabling all statistics and using the logon trigger) and send to www.oraperf.com

Anyway in sqlplus there is an
autocommit option if you set it to 10 or 100 it usually improves insert time, lots. Try it., disabling loggin in the table too.

Original Message ----- From: <Stephen.Lee_at_DTAG.Com> To: <oracle-l_at_freelists.org> Sent: Friday, February 20, 2004 1:40 PM Subject: RE: Sql loader taking too long!

Disable constraints. Alter indexes unusable. load
Rebuild indexes. Enable constraints.

> -----Original Message-----
> But using conventional takes 3 hours table nearly 7 mil rows.
> Any ideas on how to speed it up?
>

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Feb 20 2004 - 15:21:03 CST