Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Which DB instance(among 2 running instances) is preferred with Oracle TAF feature?

Re: Which DB instance(among 2 running instances) is preferred with Oracle TAF feature?

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 22 May 2005 18:16:01 -0700
Message-ID: <1116810704.866843@yasure>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US