RE: Best practices for Datawarehouse: RAC or Non-RAC

From: Holvoet, Jo <jo.holvoet_at_thomascook.be>
Date: Fri, 19 Mar 2010 14:17:56 +0100
Message-ID: <CF9A39CD0F65EA49ADF70FCBF9BC2FF7B9C496_at_SW-GNETCW-MBX02.tcads.thomascook.com>

Is the exchange partition technique still useful if, besides inserts, you have quite a bit of data already in the DW that needs to updated as well ?  

mvg,

Jo

---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still Sent: donderdag 18 maart 2010 18:56
To: tim_at_evdbt.com
Cc: ravigaur1_at_gmail.com; oracle list
Subject: Re: Best practices for Datawarehouse: RAC or Non-RAC  

On Wed, Mar 17, 2010 at 6:30 PM, Tim Gorman <tim_at_evdbt.com> wrote:

        Respectfully, I'd recommend reading
"http://www.evdbt.com/TGorman%20TD2009%20DWScale.doc"            

I just spent a few minutes re-reading this.  

It is required reading for anyone even thinking of building a data warehouse.  

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com  

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Mar 19 2010 - 08:17:56 CDT