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