Hi, all,
I'm having a problem with getting proper load-balancing on a RAC with
a JDBC connection pool. When the connection pool is created, all the
connections get routed to the least-loaded node, so when queries start
getting submitted, they all end up swamping the single node.
Unfortunately, that's what it's supposed to be doing, ie. the listener
load-balances properly because at the point of connection, the second
node is the least loaded. Is there a better way to get some balancing
at query-time versus at connect-time? Thanks in advance,
thanh
I'm having a problem with getting proper load-balancing on a RAC with
a JDBC connection pool. When the connection pool is created, all the
connections get routed to the least-loaded node, so when queries start
getting submitted, they all end up swamping the single node.
Unfortunately, that's what it's supposed to be doing, ie. the listener
load-balances properly because at the point of connection, the second
node is the least loaded. Is there a better way to get some balancing
at query-time versus at connect-time? Thanks in advance,
thanh