RE: Import with commit=Y very slow

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Wed, 22 Mar 2006 15:03:46 -0500
Message-ID: <5A14AF34CFF8AD44A44891F7C9FF410506C065AB@usahm236.amer.corp.eds.com>

Michael has a good point. The other major factor where commit=y is used is the buffer= parameter. I hope you are not importing using the default but have specified something like buffer=1048576 or larger

HTH -- Mark D Powell --

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Michael McMullen Sent: Wednesday, March 22, 2006 2:31 PM
To: oracle-l
Subject: Re: Import with commit=Y very slow

What are the columns in your table? Unless new versions have changed some column types would cause a commit=y to automatically commit every single insert.
--

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

--

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