Re: Windows Clustering and FailSafe???
Date: Fri, 07 Nov 2008 11:49:13 -0600
> 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.
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:
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