RE: Import with commit=Y very slow
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 22 Mar 2006 15:03:46 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
