Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to improve performance on dataload process

RE: How to improve performance on dataload process

From: <>
Date: Wed, 28 Sep 2005 11:43:23 +0100
Message-ID: <>

I guess, Create indexes in parallel. You should take into consideration the number of CPUs and the number of disks involved to base the parallelism on.        



-----Original Message-----

From: []On Behalf Of Zabair Ahmed Sent: 28 September 2005 10:54
Subject: How to improve performance on dataload process 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?  


To help you stay safe and secure online, we've developed the all new <*> Yahoo! Security Centre.

PLEASE READ: The information contained in this email is confidential and intended for the named recipient(s) only. If you are not an intended recipient of this email please notify the sender immediately and delete your copy from your system. You must not copy, distribute or take any further action in reliance on it. Email is not a secure method of communication and Nomura International plc ('NIplc') will not, to the extent permitted by law, accept responsibility or liability for (a) the accuracy or completeness of, or (b) the presence of any virus, worm or similar malicious or disabling code in, this message or any attachment(s) to it. If verification of this email is sought then please request a hard copy. Unless otherwise stated this email: (1) is not, and should not be treated or relied upon as, investment research; (2) contains views or opinions that are solely those of the author and do not necessarily represent those of NIplc; (3) is intended for informational purposes only and is not a recommendation, solicitation or offer to buy or sell securities or related financial instruments. NIplc does not provide investment services to private customers. Authorised and regulated by the Financial Services Authority. Registered in England no. 1550505 VAT No. 447 2492 35. Registered Office: 1 St Martin's-le-Grand, London, EC1A 4NP. A member of the Nomura group of companies.

-- Received on Wed Sep 28 2005 - 05:46:46 CDT

Original text of this message