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

Home -> Community -> Mailing Lists -> Oracle-L -> Import with commit=Y very slow

Import with commit=Y very slow

From: Alfonso León <aleon68_at_gmail.com>
Date: Wed, 22 Mar 2006 14:14:37 -0500
Message-ID: <83a585ac0603221114m514db016o7652955f93a15399@mail.gmail.com>


Hi everybody:

I'm importing a table with 9M records and when I use commit=N it takes about 5 hours and with commit=Y it takes about 14hours. (NO INDEXES)

Would anybody can tell me why? it shouldn't take longer the commit=N?

I'm using Oracle Enterprise 10.2 and the export file is from 9.2.0.6. with UNDO tablespace of 3 GB.

TIA
--

Alfonso Leon
--

http://www.freelists.org/webpage/oracle-l Received on Wed Mar 22 2006 - 13:14:37 CST

Original text of this message

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