How to improve performance on dataload process
- From: Zabair Ahmed <roon987@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 28 Sep 2005 10:54:26 +0100 (BST)
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.
Other related posts:
