This content has been marked as final. Show 5 replies
this should answer most questions.
However in your special case it may well be that you opened the connections all at once.
For serverside loadbalancing PMON will inform the remote listeners about the actual status every 60 seconds.
So if all sessions are connecting at the same time, what you see might be expected.
If you use connection pools, and the features showed in the above whitepaper, this should equal over time.
To circumvent this from happening, it may help to use LOAD_BALANCE in the client tnsnames.ora as well.
Thanks Sebastian for the info.
White paper has information related to SCAN. We are not using SCAN feature. Also, we have (LOAD_BALANCE=ON) in client TNSNAMES.
Edited by: 905267 on Nov 8, 2012 4:12 AM
Hi,1 person found this helpful
on www.oracle.com/goto/rac there is also the 11.1 paper, which has the same information without SCAN.
Furthermore: Why are you not using SCAN?
Thanks for reply. SCAN feature is not used since my client doesnt have DNS configured.
Yesterday, We found that Load balancing may be not happening as during installation application team didnt used failover string to connect to DB so may be all connections were routing to DB2. Morning when I came in I found that the connections are evenly distributed.
Just need to check if load balanceing is happening or not. Please help me with a test case to check load balanceing from client end.