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