Tom, We do use Tuxedo, but I was investigating what we can have on the DB layer. Thanks, Alex From: Tim Gorman <tim@xxxxxxxxxxxxx>@freelists.org on 30-07-2004 01:29 CST 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 Alexandre, You should consider using a transaction-processing monitor such as BEA Tuxedo, IBM Encina, or NCR Top End in the tier above the database. These high-end tools are capable of this kind of rules-based or load-based distribution of transactions amongst different "resource managers". Hope this helps... -Tim on 7/26/04 3:26 PM, Alexandre Gorbatchev at 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 > ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------