Re: insert performance

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

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:


      Dev Env.  -  Oracle Database 10g Enterprise Edition Release, Windows 2000 server, Quest datafactory  5.5 to load sample

     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

*Arvind Kumar*

Associate  Consultant
Siemens Information Systems Limited
e-mail : *arvind.kumar@xxxxxxxxxxx*

-- ----------------------------------------

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: