Best practices for Datawarehouse: RAC or Non-RAC
From: Ravi Gaur <ravigaur1_at_gmail.com>
Date: Wed, 17 Mar 2010 12:43:07 -0500
Message-ID: <289232291003171043j27d084b6va3b61a01cc51f6fb_at_mail.gmail.com>
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).
Date: Wed, 17 Mar 2010 12:43:07 -0500
Message-ID: <289232291003171043j27d084b6va3b61a01cc51f6fb_at_mail.gmail.com>
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 - 12:43:07 CDT