RE: Load balancing with RAC according to our own proportions

  • From: Alexandre Gorbatchev <agorbatchev@xxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 27 Jul 2004 07:38:58 +0200

Pete,
It's 9i and I don't foresee migration to 10g in the short term.

Thanks for mentioning it,
Alex



From:   Pete Sharman <peter.sharman@xxxxxxxxxx>@freelists.org  on 
27-07-2004 08:30 ZE10
Please respond to oracle-l@xxxxxxxxxxxxx
Sent by:        oracle-l-bounce@xxxxxxxxxxxxx

To:
oracle-l@xxxxxxxxxxxxx



cc:
Peter Ross Sharman <PETER.SHARMAN@xxxxxxxxxx>









Subject:
RE: Load balancing with RAC according to our own proportions





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
-----------------------------------------------------------------





----------------------------------------------------------------
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: