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

From: Stefano Cislaghi <>
Date: Wed, 17 Mar 2010 20:17:51 +0100
Message-ID: <>


Sure RAC may work well in a datawarehouse system, but you have IMHO to check your apps and jobs if are able to work in a RAC database. Also if you use legacy applications check with your vendor if there're known issues with RAC or not.

RAC address many misconceptions and it's vital for you to know really well what you're doing in your env.
Check this doc:



2010/3/17 Ravi Gaur <>:

> 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
Received on Wed Mar 17 2010 - 14:17:51 CDT

Original text of this message