RE: Load balancing with RAC according to our own proportions

  • From: Pete Sharman <peter.sharman@xxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 27 Jul 2004 08:30:34 +1000

Have you looked at the services functionality in 10g?

 =

Pete
 =

"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
 =

"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] =
On Behalf Of Alexandre Gorbatchev
Sent: Tuesday, 27 July 2004 7:27 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Load balancing with RAC according to our own proportions

Hi all,
Could you please share your experience with client load balancing with RAC =
=

in 9i?
Oracle can do it on its own during connection time but this wouldn't suit =

our need. We want to define proportions in which connections should be =

distributed over different nodes. I suppose it's not possible with =

standard Oracle Net architecture. The applications are connecting over OCI =
=

if it makes any difference. We are using dedicated sessions. Sessions are =

persistent and normally stay connected for days if not months. I think we =

can initiate reconnect if we need to re-balance but I still don't see any =

option of how to balance connections automatically by Oracle.
For now, I see only application specific approach - the app would have to =

choose which of the instances it should connect to. Please correct me if =

I'm wrong. Any ideas would be appreciated.

Regards,
Alex

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: