Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: RAC and DataWarehouse
Thanks Daniel.
I read something about the parallel queries that perform better in RAC environment than a single node. Something about parallelism that is done across nodes (using the other node CPU) even though the query is executed against one node. Not able to locate the document.
DA Morgan wrote:
> 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
Received on Mon Jun 19 2006 - 15:15:53 CDT