RE: How to improve performance on dataload process
- From: "Ian Cary (C)" <Ian.Cary@xxxxxxxxxxxxxxxxxxxx>
- To: <roon987@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 28 Sep 2005 11:44:58 +0100
Don't use Informatica :)
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Zabair Ahmed
Sent: 28 September 2005 10:54
To: oracle-l@xxxxxxxxxxxxx
Subject: How to improve performance on dataload process
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
<http://us.rd.yahoo.com/mail/uk/taglines/default/security_centre/*http://uk.security.yahoo.com/>
Yahoo! Security Centre.
This email and any attachments have been virus checked upon receipt at Ordnance
Survey and are free of all known viruses.
This email is only intended for the person to whom it is addressed and may
contain confidential information. If you have received this email in error,
please notify the sender and delete this email which must not be copied,
distributed or disclosed to any other person.
Unless stated otherwise, the contents of this email are personal to the writer
and do not represent the official view of Ordnance Survey. Nor can any contract
be formed on Ordnance Survey's behalf via email. We reserve the right to
monitor emails and attachments without prior notice.
Thank you for your cooperation.
Ordnance Survey
Romsey Road
Southampton SO16 4GU
Tel: 023 8079 2000
http://www.ordnancesurvey.co.uk
Other related posts:
