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

Home -> Community -> Usenet -> c.d.o.server -> Re: Performance problems with Oracle EE 8iR2 on 64 Bit Solaris

Re: Performance problems with Oracle EE 8iR2 on 64 Bit Solaris

From: Alexander Penev <penev_at_cska.net>
Date: Fri, 22 Dec 2000 22:35:57 GMT
Message-ID: <3A43D74B.D2D8498E@cska.net>

> 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

Original text of this message

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