RAC and load-balancing a connection pool
From: Thanh <thnguyen99_at_yahoo.com>
Date: 5 Mar 2004 07:48:01 -0800
Message-ID: <386645ad.0403050748.1768f95f_at_posting.google.com>
Date: 5 Mar 2004 07:48:01 -0800
Message-ID: <386645ad.0403050748.1768f95f_at_posting.google.com>
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 - 16:48:01 CET