Re: insert performance

---

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