Re: Windows Clustering and FailSafe???

jeffchirco_at_gmail.com wrote:
> Anybody out there using Windows clustering service and Oracle Fail
> Safe running 10g or 11g? RAC is just too expensive for us so we are
> looking at this solution but we know very little about it. For one
> does it support a active/active solution where both nodes can share
> the load of one database. Or will only support a active/passive
> solution. Any input will be very helpful. Thank you.
>
> Jeff

The question would be what is the driver for the need for active/active?

   Performance? Workload? Other?

Things to consider when spinning up Oracle - for ANY database:

Performance
Availability
Capacity

You really need to determine the primary usage, THEN select your platform based on the need. I would not put my primary database on anything Windows-based. There are far too many restrictions on performance (Memory, CPU capacity, Network connectivity) that were never   designed to be able to handle some workloads.

If you are 9i and/or 10g - make sure you TURN OFF HYPER-THREADING (BIOS setting)!!! I have in the past resolved a severe performance issue on 10g by this simple configuration change. Do not listen to the SA-types that think they know better. :) Transactions w/o HT were executing in 10-20ms. W/HT, it was 375-410ms. And this was the only change made and we used several different "servers" from the major vendors. Received on Fri Nov 07 2008 - 11:49:13 CST