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_at_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_at_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 - 15:43:54 CDT
