If you can use Oracle DataPump then it is much faster.
From: "Juan Carlos Reyes Pacheco" <juancarlosreyesp@xxxxxxxxx>
Reply-To: juancarlosreyesp@xxxxxxxxx
To: arvind.kumar2@xxxxxxxxxxx
CC: oracle-l@xxxxxxxxxxxxx
Subject: Re: insert performance
Date: Mon, 25 Sep 2006 16:43:54 -0400
Hi,
Some times recreating the table as create as select nologging, is faster than inserting.
arvind.kumar2@xxxxxxxxxxx> wrote:Gurus,
Dev Env. - Oracle
Database 10g Enterprise Edition Release 10.2.0.1.0, Windows 2000 server, Quest datafactory 5.5 to load sample data.
How can I improve the Insert performance
while loading data into two tables (a parent with one child)? If I am saving the generated data (1 Million rows) from datafactory into .CSV file it takes only 40 minutes , for the same volume it takes 2 hour if loading into Oracle tables.
I have set COMMIT_WRITE = BATCH,NOWAIT to
avoid log_file_sync Wait event.
Arvind Kumar
Associate
Consultant
Siemens Information Systems Limited
e-mail : arvind.kumar@xxxxxxxxxxx
--
----------------------------------------
http://www.oracleboliviaspecialists.com/
Oracle Certified Profesional 9i 10g
Orace Certified Professional Developer 6i
10 years of experience from Oracle 7 to Oracle10g and developer 6i