Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: RAC and load-balancing a connection pool

Re: RAC and load-balancing a connection pool

From: Thanh <thnguyen99_at_yahoo.com>
Date: 12 Mar 2004 13:34:33 -0800
Message-ID: <386645ad.0403121334.50f158d1@posting.google.com>


Thank you, all for your input. I was expecting this, so I'm not too terribly disappointed. We'll just have to figure out something on the middleware level to do it. Thanks again.

news:<4050baf5$0$3958$afc38c87_at_news.optusnet.com.au>...
> "Thanh" <thnguyen99_at_yahoo.com> wrote in message
> news:386645ad.0403101046.67b11c_at_posting.google.com...
> > 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
>
>
Received on Fri Mar 12 2004 - 15:34:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US