RE: Improper Load Balancing
- From: "Eric Gross" <egross@xxxxxxxxxxx>
- To: <dofreeman@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 22 Mar 2007 10:59:25 -0400
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@xxxxxxxxxxx
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Freeman, Donald
Sent: Thursday, March 22, 2007 8:55 AM
To: oracle-l@xxxxxxxxxxxxx
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
Other related posts:
