Re: insert performance

  • From: "Juan Carlos Reyes Pacheco" <juancarlosreyesp@xxxxxxxxx>
  • To: arvind.kumar2@xxxxxxxxxxx
  • Date: Mon, 25 Sep 2006 16:43:54 -0400

Hi,
Some times recreating the table as create as select nologging, is faster
than inserting.

On 9/25/06, Kumar, Arvind IN GGN SISL <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

Other related posts: