Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Import with commit=Y very slow

Re: Import with commit=Y very slow

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 22 Mar 2006 16:56:11 -0800
Message-ID: <bf46380603221656idd04a6ew5c2147914845cd6f@mail.gmail.com>


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

>

> it is doing a commit per record.
> Thanks.

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
Received on Wed Mar 22 2006 - 18:56:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US