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

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

Re: Load balancing with RAC according to our own proportions

From: Alexandre Gorbatchev <agorbatchev_at_amadeus.net>
Date: Mon, 2 Aug 2004 09:15:20 +0200
Message-ID: <OF751C9E19.C99627EF-ONC1256EE4.0025003C-C1256EE4.0027D983@amadeus.net>


Tom,
We do use Tuxedo, but I was investigating what we can have on the DB layer.

Thanks,
Alex

From: Tim Gorman <tim_at_sagelogix.com>@freelists.org on 30-07-2004 01:29 CST
Please respond to oracle-l_at_freelists.org Sent by: oracle-l-bounce_at_freelists.org

To:
<oracle-l_at_freelists.org>

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_at_amadeus.net 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_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
> -----------------------------------------------------------------



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





----------------------------------------------------------------
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 Aug 02 2004 - 02:11:41 CDT

Original text of this message

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