Oracle RAC Database Load Imbalance
AminuOct 28 2011 — edited Oct 28 2011My company has hired a consultant to deploy a RAC database 11g for our enterprise application. Load Balancing is enabled both at the Application side and Database side. We have paid for a 32 core license and each RAC node has *32 core*s (*4 processors, 8 cores each*) making a total of *64 cores for both RAC nodes*. The application is a web application deployed using WebLogic Enterprise and we use Oracle Database 11g R2. Since the deployment all workload appears to be concentrated entirely on one node at any particular time. Sometimes the load simply shifts from one node to the other but we hardly have a balanced situation where both nodes are equally utilized. One more surprising thing is that the number of sessions on both nodes are almost equal at all times when we query gv$session. What could be causing this load imbalance? Someone please help!!!