RE: Improper Load Balancing

Don-  

The default load balancing goal in RAC is "long connections" - this works best for clients who are going to be connected for an extended period. When you have many short-lived connections you may investigate changing your TAF policies to account for the "short connections" - here's a reference:  

http://download-east.oracle.com/docs/cd/B19306_01/rac.102/b14197/hafeats .htm#RACAD7122  

Thanks,
e.

Eric Gross
Mr. Database
GridApp Systems
Ph: (646) 452-4050
egross_at_gridapp.com  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Freeman, Donald Sent: Thursday, March 22, 2007 8:55 AM
To: oracle-l_at_freelists.org
Subject: Improper Load Balancing

We are experiencing problems with the database connectivity from the production web servers for the last 2-3 weeks. We are using Oracle RAC in the production and there are 2 database servers. Somehow the connection goes to one database server intermittently, not all the time. But when it happens we see most of the connections going to the same Oracle node i.e. second node. We are using Windows load balancing on the web servers. Does anybody have any idea what might cause this?

Don Freeman
Database Administrator 1
Bureau of Information Technology
Pennsylvania Department of Health
(717) 703-5782

--
http://www.freelists.org/webpage/oracle-l