Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RAC load balancing advice

755353May 26 2010 — edited May 28 2010

Hi guys,

I’m in process of creating services for our RAC databases to ensure the system resources are efficiently utilized. Below is some info about my environment.
2 node rac. 7 databases ,V11.2 and 10.2 ,system users: developers, testers
Goal: to distribute the load as much as possible no prioritization is needed and all users have same SLA.

I’m thinking of having one service for every database with following characteristics:

Connection load balancing:=long (default)
DBMS_SERVICE.GOAL=GOAL_THROUGHPUT
Preferred instances: node1, node2
Is thats the most efficient way of doing it?
thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 24 2010

Added on May 26 2010

#performance-availability, #real-application-clusters

16 comments

2,865 views