Need for client side load Balancing
I am trying to understand the need of client side load balancing support (in an RAC environment) provided by the Oracle Universal Connection Pool (UCP). As I understand, when the connection request is made, the scan name is resolved by the DNS to a SCAN listener VIP address. This is done in a round robin manner.
The round robin algorithm would ensure that one specific SCAN listener is not overloaded. Since SCAN is used, it will make sure that the request is connected to a least loaded node, instance and a dispatcher. Also since VIP (Virtual Private Addresses) are used for SCAN, this will ensure quick connection fail-over (instead of waiting for TCP timeouts).
Isn't this enough for load balancing? It would be nice to have an experts opinion on this. Thank you.