Re: How to improve performance on dataload process

There is a buffer size setting in informatic, and using the direct load option, if you are using informatic 6.1 or above.

On 9/28/05, Zabair Ahmed <roon987_at_yahoo.co.uk> wrote:
>
> 9.2.0.6 <http://9.2.0.6/> on Solaris 9
> Am loading data into a staging database using a ETL tool (Informatica)
> and have done the following to improve the performance of the dataload
> process
> 1) Database in no-archive log mode
> 2) Indexes being built after the dataload
> 3) Load being done in parallel
> 4) Nologging being used
> 5) Tables not being analysed during the dataload process
> What else can I do to improve the performance of this load process?
> TIA
>
> ------------------------------
> To help you stay safe and secure online, we've developed the all new *Yahoo!
> Security Centre*<http://us.rd.yahoo.com/mail/uk/taglines/default/security_centre/*http://uk.security.yahoo.com/>
> .
>
>

--
Welcome, Fangxin.Lou from China
MYDUL, alternative to DUL !!!
Home: http://www.anysql.net/en/
Mydul: http://www.anysql.net/en/mydul.html

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