Load Balancing and Oracle Net Services

Many applications like to balance their workloads across all the instances of an Oracle RAC database. Usually, load balancing with Oracle (excluding the parallel feature) meant connection load balancing—that is, the connections to the database are balanced on a “round-robin” basis, CPU load, or session count at connect time. With Oracle Net Services, there are two types of connection load balancing: one on the client side and the other on the server side.

NOTE

The discussion about connect-time load balancing is for dedicated connections only. Shared server connections can also take advantage of these features but are not discussed here.

Client-Side Load Balancing

Oracle’s client-side load balancing feature ...

Get Oracle Database 11g Oracle Real Application Clusters Handbook, 2nd Edition, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.