Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Performance problems with Oracle EE 8iR2 on 64 Bit Solaris
> Hi,
> Since the performance is different between normal/Direct mode Import, you
> should investigate this fact before to investigate more genaral tuning
> problem (underuse of memory, I/O contention, etc ...).
>
Thank you, it has increased the preformance of sqlloader (direct mode) by 300%
>
> Try to increase the Large_pool_size ( 64 Mb or more ?). During Oracle 8i
> lesson, I understood that this buffer is used by the DIRECT mode insert to
> avoid DB buffer cache wastage.
Received on Fri Dec 22 2000 - 16:35:57 CST