Re: Best practices for Datawarehouse: RAC or Non-RAC
From: Tim Gorman <tim_at_evdbt.com>
Date: Wed, 17 Mar 2010 19:30:23 -0600
Message-ID: <4BA1822F.5010601_at_evdbt.com>
Respectfully, I'd recommend reading
"http://www.evdbt.com/TGorman%20TD2009%20DWScale.doc"
Date: Wed, 17 Mar 2010 19:30:23 -0600
Message-ID: <4BA1822F.5010601_at_evdbt.com>
Respectfully, I'd recommend reading
"http://www.evdbt.com/TGorman%20TD2009%20DWScale.doc"
Ravi Gaur wrote:
> I'm sure this topic has been brought up several times before. I'm
> looking for some documentation /advice for building a new
> Datawarehouse. It will have the nightly ETL feeds, denormalization,
> long running queries etc. so I'm looking for some best practices if
> someone can point me to. Specifically any down-sides of using RAC.
> Our hardware is Sun (sun-fire-v495's which will eventually move to
> T5440s).
> The OLTP databases that will feed this are a mix of RAC and non-RAC
> databases (if that matters).
>
> TIA,
>
> - Ravi Gaur
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 17 2010 - 20:30:23 CDT