Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: [Q] How to do ORACLE RAC load balance?
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.
-- 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
![]() |
![]() |