How to improve performance on dataload process

From: Zabair Ahmed <roon987_at_yahoo.co.uk>
Date: Wed, 28 Sep 2005 10:54:26 +0100 (BST)
Message-ID: <20050928095426.50023.qmail@web25408.mail.ukl.yahoo.com>

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://www.freelists.org/webpage/oracle-l Received on Wed Sep 28 2005 - 04:56:34 CDT