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: How to improve performance on dataload process

Re: How to improve performance on dataload process

From: Lou Fangxin <anysql_at_gmail.com>
Date: Wed, 28 Sep 2005 20:12:10 +0800
Message-ID: <ea5907d30509280512289ab4d2@mail.gmail.com>


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
Received on Wed Sep 28 2005 - 07:14:19 CDT

Original text of this message

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