Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: insert performance

Re: insert performance

From: Binh Pham <binhpham15_at_hotmail.com>
Date: Mon, 25 Sep 2006 23:51:34 +0000
Message-ID: <BAY103-F51FD439D7D355305F4B31D2240@phx.gbl>

If you can use Oracle DataPump then it is much faster.


From:  "Juan Carlos Reyes Pacheco" <juancarlosreyesp@gmail.com>
Reply-To:  juancarlosreyesp@gmail.com
To:  arvind.kumar2@siemens.com
CC:  oracle-l@freelists.org
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.

On 9/25/06, Kumar, Arvind IN GGN SISL <
arvind.kumar2@siemens.com> 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@siemens.com

 




--
----------------------------------------
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

-- http://www.freelists.org/webpage/oracle-l Received on Mon Sep 25 2006 - 18:51:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US