Re: [Q] How to do ORACLE RAC load balance?

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Wed, 28 Jul 2004 05:43:51 -0700 (PDT)
Message-ID: <20040728124351.50317.qmail@web41501.mail.yahoo.com>

Hi MccDBA:

I think you are (or he is ) talking about Listener Load Balancing. In LLB we register the listener name and addresses to all nodes using local listener and remote listener parameters. PMON process updates the CPU load (plus some other stuff) to the other listener once in 5 minutes and the new connections are routes to the least loaded node.

However, this may be of an issue when all connections comes in a period of 5 minutes (like 'logon storms'). In this case you should not depend on LLB and use the CTLB (Connect time Load Balancing or Client Side Load Balancing) using the TNSNAMES.ORA file. This is just a round robin load balancing as one connection go to one instance and other connection goes to other instance.. etc.

I am not an Application Server/Mid Tier expert. So I leave that question to some one else.

• dba1 mcc <mccdba1_at_yahoo.com> wrote:
  > I attended ORACLE seminal and speaker mention ORACLE
  > RAC check each node "PMON" to decide "load balance".
  > He also suggest use "connection pool (mid tier)" for
  > load balance instead of client/server. I don't quite
  > understand what he said and have some questions:
  >
  >
  > 1. How to check "PMON" to know each node system load?
  >
  > 2. why "connection pool" will have better loas
  > balance?
  >
  

  ---

Have a nice day !!

---

Best Regards,
K Gopalakrishnan,
Co-Author: Oracle Wait Interface: Oracle Press 2004. http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/                 

---

Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail

---

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 Wed Jul 28 2004 - 07:40:34 CDT