Re: insert performance

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.

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

-- http://www.freelists.org/webpage/oracle-l

Other related posts: