Re: oracle 10 rac is possible manage workload

From: Michael Austin <maustin_at_firstdbasource.com>
Date: Fri, 05 Jan 2007 03:13:17 GMT
Message-ID: <hnjnh.13675$yC5.6435@newssvr27.news.prodigy.net>

DA Morgan wrote:

> Alessandro Lagostena wrote:
>

>> Hello all
>>
>> I'm new of oracle rac and i need if is possible configure 2 oracle 
>> server using RAC and to share the workload 80 % on one server and 20 % 
>> on other one
>>
>> Is this possible on configuration of oracle server ?
>>
>> Thanks and regards
>>
>> LAGO

>
>
> RAC load balancing is not percentage based. What you can likely do is
> create multiple services ... with one group of users connecting to one
> service and the other group of users connecting to the other.
>
> But it would be really helpful to understand the business case.

No to mention for HA (high availability) you really want somewhat less than 50/50 (n+1?) because if the servera running at 80%CPU fails, serverb will be automatically max'ed out at 100% and things would begin to get real slow after that....

-- 
Michael Austin.
Database Consultant

Received on Thu Jan 04 2007 - 21:13:17 CST