Sql loader taking too long! 2004-02-20 - By Juan Cachito Reyes Pacheco
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@(protected) >
To: <oracle-l@(protected) >
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@(protected)
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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
