Re: RAC and DataWarehouse

wagen123_at_yahoo.com wrote:
> Hi,
>
> Oracle10g 10.2.0.x (64 bit)
> Linux RHEL AS 4.3 (64 bit)
>
> Can anyone share their experiences of using a Datawarehousing in a RAC
> environment?
> What are the advantages/disadvantages?
> Any documents/white papers?
>
> Thanks for any pointers.
>
> wagen

Many advantages only two disadvantages. Here are the two negatives.

1. You need training on how to install, configure, tune, and maintain a RAC environment
2. It costs money buy the licenses

Here are some of the more obvious advantages.

1. Lower hardware cost
2. Eliminates server failure as a risk factor to 7x24x365 operations
3. Transparent failover via TAF or FCF
4. Incremental scalability
5. Application consolidation (lower maintenance cost)
6. Often lower cost to Oracle (depends on consolidation metrics) -- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org