From oracle-l-bounce@freelists.org Mon Jul 26 17:35:23 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6QMYwN11493 for ; Mon, 26 Jul 2004 17:35:08 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i6QMYl611366 for ; Mon, 26 Jul 2004 17:34:57 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1890472E2E0; Mon, 26 Jul 2004 17:13:14 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 31684-99; Mon, 26 Jul 2004 17:13:13 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 343C672E2D6; Mon, 26 Jul 2004 17:13:11 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 26 Jul 2004 17:11:29 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4989172CEE5 for ; Mon, 26 Jul 2004 17:11:28 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 32078-14 for ; Mon, 26 Jul 2004 17:11:28 -0500 (EST) Received: from agminet03.oracle.com (agminet03.oracle.com [141.146.126.230]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CA98A72CA5F for ; Mon, 26 Jul 2004 17:11:27 -0500 (EST) Received: from rgmgw3.us.oracle.com (rgmgw3.us.oracle.com [138.1.191.12]) by agminet03.oracle.com (Switch-3.1.4/Switch-3.1.0) with ESMTP id i6QMUhXt017388 for ; Mon, 26 Jul 2004 15:33:20 -0700 Received: from localhost (localhost [127.0.0.1]) by rgmgw3.us.oracle.com (Switch-3.1.4/Switch-3.1.0) with SMTP id i6QMUhcb011725 for ; Mon, 26 Jul 2004 16:30:43 -0600 Received: from au.oracle.com (dhcp-tda3-tdb3-tdc3-tdr3-east-144-25-182-114.us.oracle.com [144.25.182.114]) by rgmgw3.us.oracle.com (Switch-3.1.4/Switch-3.1.0) with ESMTP id i6QMUaW6011477; Mon, 26 Jul 2004 16:30:36 -0600 Message-Id: <200407262230.i6QMUaW6011477@rgmgw3.us.oracle.com> From: Pete Sharman To: oracle-l@freelists.org Cc: Peter Ross Sharman Subject: RE: Load balancing with RAC according to our own proportions Date: Tue, 27 Jul 2004 08:30:34 +1000 X-Sent-Folder-Path: Sent Items X-Mailer: Oracle Connector for Outlook 9.0.4 60130 (10.0.4712) MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 6089 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: peter.sharman@oracle.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@freelists.org [mailto:oracle-l-bounce@freelists.org] = On Behalf Of Alexandre Gorbatchev Sent: Tuesday, 27 July 2004 7:27 AM To: oracle-l@freelists.org 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@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@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 -----------------------------------------------------------------