RAC load balancing
I am trying to get a 3-node RAC to balance connections more evenly . Many times one or two machines becomes very overloaded and the third is hardly doing anything but new connections keep going to the overloaded ones.
I have tried in a test RAC 2-node setup to create a new service ( preferred to both instances) and was hoping the LBA would push new connections to the least used server but I am not seeing that happen and when I look at sys.sys$service_metrics_tab I see the entries for the new service always at percent=50 for both instance and the flag=UNKNOWN. FYI, the connections I am testing with are DBMS_SCHEDULER jobs because that is a big part of this application .
Do I have something not setup right ? or is what I am trying to do not possible ? We are at 10.2.0.4 does LBA work beter with 11g ? Following is some info on environment I am testing with.
(BATCHQ_GDRT_SERVICE, VERSION=1.0 database=gdrt service=BATCHQ_GDRT_SERVICE { {instance=gdrt2 percent=50 flag=UNKNOWN}{instance=gdrt1 percent=50 flag=UNKNOWN} } timestamp=2012-02-08 11:10:40)
wape0taa [gdrt1]> srvctl config service -d gdrt -s batchq_gdrt_service
batchq_gdrt_service PREF: gdrt1 gdrt2 AVAIL:
INST_ID NAME GOAL CLB_GOAL
1 BATCHQ_GDRT_SERVICE SERVICE_TIME SHORT
2 BATCHQ_GDRT_SERVICE SERVICE_TIME SHORT