Re: RAC and DataWarehouse

On 2006-06-19, wagen123_at_yahoo.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.

        Based on the numbers that Oracle publishes, it pretty much boils down to what you will be more comfortable with. RAC requires a more complex system. The systems and networking side of thing will require better tech and admins to deal with if you're using RAC. A relative newbie will be able to deal with a NUMA based solution much easier. The "cluster" is transparent on a Sunfire and something you have to manually nuture on the RAC side of things.

        If you go with RAC, DO NOT skimp on the storage hardware. That will be your single remaining unavoidable point of failure in the cluster. It needs to be more robust and manageable than the rest of the system. Depending on how tolerant your app is to node failures, your server hardware can be nearly disposable.

[deletia]

-- 
	OpenDoc is moot when Apple is your one stop iShop.      |||
				                               / | \   

 Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
    ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------        
                http://www.usenet.com