Import with commit=Y very slow

  • From: "Alfonso León" <aleon68@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 22 Mar 2006 14:14:37 -0500

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
with UNDO tablespace of 3  GB.


Alfonso Leon

Other related posts: