Re: Best practices for Datawarehouse: RAC or Non-RAC
- From: Tim Gorman <tim@xxxxxxxxx>
- To: ravigaur1@xxxxxxxxx
- Date: Wed, 17 Mar 2010 19:30:23 -0600
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-l
Other related posts: