Re: RAC and DataWarehouse

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 19 Jun 2006 15:17:31 -0700
Message-ID: <1150755454.945908@bubbleator.drizzle.com>

wagen123_at_yahoo.com wrote:

> 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

Please don't top post.

http://oraclesvca2.oracle.com/docs/cd/B19306_01/rac.102/b14197/votocr.htm The CLUSTER_INTERCONNECTS initialization parameter is useful only in a UNIX-based environments where UDP IPC is enabled. The CLUSTER_INTERCONNECTS parameter enables you to specify an interconnect for all IPC traffic to include Oracle Global Cache Service (GCS), Global Enqueue Service (GES), and Interprocessor Parallel Query (IPQ).

check out tahiti.oracle.com for more.

-- 
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 - 17:17:31 CDT