Re: RAC and load-balancing a connection pool

thnguyen99_at_yahoo.com (Thanh) wrote:
> I posted this in comp.databases.oracle, but no response, so I figured
> I might try this newsgroup as well. Thank you.
>
> thnguyen99_at_yahoo.com (Thanh) wrote in message
> news:<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

Couldn't you set the connection pool manager to create new connections only when they are needed (i.e. when all other connections are already checked out, or when the last connection is checked out)?

Or to occasionally close and reopen connections, so they migrate to the currently least loaded node?

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB