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

Home -> Community -> Mailing Lists -> Oracle-L -> Load balancing with RAC according to our own proportions

Load balancing with RAC according to our own proportions

From: Alexandre Gorbatchev <agorbatchev_at_amadeus.net>
Date: Mon, 26 Jul 2004 23:26:52 +0200
Message-ID: <OF1D143100.FB19C5ED-ONC1256EDD.0059C6CD-C1256EDD.0075D090@amadeus.net>


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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Mon Jul 26 2004 - 16:24:33 CDT

Original text of this message

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