Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Which DB instance(among 2 running instances) is preferred with Oracle TAF feature?
K Gopalakrishnan wrote:
> Hi,
>
> When you have TAF configured without load balance at the client side,
> it will always go the first connection. If it is not able to connect
> the first named connection, it will go to the subsequent connection. If
> you specify the load balance it just uses the round robin method and
> choose the connections alternatively. Remember TAF is the feature from
> the network layer, not servics layer.
Minor correction. Oracle does not round robin when you ask for load balancing. The connections are smart enough to know which machines are burdened and to take into account which machines have faster CPU, faster bus, etc.
I have seen many times when the first 10+ connections go to a single node before the balancing sees any reason to move subsequent connections to other nodes.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Sun May 22 2005 - 20:16:01 CDT