Re: Import with commit=Y very slow

On 3/22/06, Alfonso León <aleon68_at_gmail.com> wrote:

>

You may want to take a look at the following parameters: buffer: size of buffer that import fills before commit recordlength: size of buffer that fills before write to disk

If you want to keep commit=y, set the buffer size to some non-default value. Experiment with it a bit.

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/ch02.htm#1014036

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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