Ok. As I thought we will probably end up with our own mechanism. We are not ready for 10g yet and it might not come to our production for another year or two. Regards, Alex From: Murali Vallath <murali_vallath@xxxxxxxxx>@freelists.org on 26-07-2004 20:37 MST Please respond to oracle-l@xxxxxxxxxxxxx Sent by: oracle-l-bounce@xxxxxxxxxxxxx To: oracle-l@xxxxxxxxxxxxx cc: Subject: Re: Load balancing with RAC according to our own proportions I don't think I have seen this done out of the box in Oracle 9i, unless you want to do this by writing some code yourself. In Oracle 10g, this is possible using the distributed workload management feature and the service framework features. Murali Vallath. Alexandre Gorbatchev <agorbatchev@xxxxxxxxxxx> wrote: 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 ----------------------------------------------------------------- Murali Vallath Author : Oracle Real Application Clusters (digital press) Join the Oracle RAC-SIG at www.oracleracsig.org - its FREE! --------------------------------- Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. ---------------------------------------------------------------- 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 -----------------------------------------------------------------