RAC and load-balancing a connection pool

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 Received on Fri Mar 05 2004 - 09:48:01 CST