Re: Import with commit=Y very slow
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: aleon68@xxxxxxxxx
- Date: Wed, 22 Mar 2006 16:56:11 -0800
On 3/22/06, Alfonso León <aleon68@xxxxxxxxx> 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
Other related posts:
