Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: [Q] How to do ORACLE RAC load balance?
I have not done RAC yet so I cannot answer your first question but the
second one is not RAC specific. The reason connection pooling will work
better is that connection pooling works by predefining a fixed number of
connections to the database that are persistant. There is only the
initial cost of setting up the connections and no cost to tearing them
down since they persist.
In client/server each time you want to check you would connect costing you the listener fork/exec cost for new process creation and the network socket setup costs. This does not inhere in CS connections but I infer it from the context of your question.
I suspect that the answer to the first question is that load balancing on RAC is automatic and the software checks pmon, not you. This answer is pure guess.
Allan
-----Original Message-----
=46rom: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc
Sent: Wednesday, July 28, 2004 7:35 AM
To: oracledba_at_LazyDBA.com; oracle-l_at_freelists.org
Subject: [Q] How to do ORACLE RAC load balance=3F
I attended ORACLE seminal and speaker mention ORACLE RAC check each node "PMON" to decide "load balance".=20 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:
Thanks.
=09
___________________________________________________________________________=___
![]() |
![]() |