RE: Tuning a warehouse

From: Rama Malladi <rmalladi_at_inteliant.com>
Date: Wed, 29 Nov 2000 17:04:33 -0800
Message-Id: <10695.123276@fatcity.com>

Hi...
 You did not specify what method you use to populate the data for the ware house (like SQL*Loader, OWB etc...)... But the following can help.

• If you are using SQL*Loader, set direct=Y, Parallel=True.
• Drop the Indexes during the Load.
• Set the Logging to no for the tables being loaded. Disable Archiving, if it is set.
• Enable Parallel DML.
• You can also see if Tablespaces can be Transported, for some huge tables.
• Partition huge tables and start loading parallel on each partition.

Hope it helps ...
Rama

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of cemail_at_sprintmail.com
Sent: Wednesday, November 29, 2000 4:26 PM To: Multiple recipients of list ORACLE-L Subject: Tuning a warehouse

Have a data warehouse, Oracle 8.0.5, HPUX. Does anyone have any suggestions for tuning the DB so that the data loads go faster?  We have some small redo logs which I am going to resize so that they are larger, but what are some other suggestions specific to warehouses and data loads?

---

Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere!

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: cemail_at_sprintmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Nov 29 2000 - 19:04:33 CST