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

TIA

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


Other related posts: