RE: RAC Node Preference for sessions
Date: Wed, 6 Feb 2013 12:45:15 -0600
Message-ID: <F05D8DF1FB25F44085DB74CB916678E885712FF339_at_NADCWPMSGCMS10.hca.corpad.net>
Yeah I was reading that before. It isn't as clear as I would like and this is a 10g service.
I did change the goal to throughput and left the CLB_GOAL as LONG - the goodness on the gv$servicemetric seems to be pretty even now and it seems our load has balanced out *HOWEVER* we also did a hardware upgrade and bios update on the rac nodes so I'm not sure which has made a difference (or if its all in my head).
Thanks,
Chris
-----Original Message-----
From: Martin Klier [mailto:usn_at_usn-it.de]
Sent: Wednesday, February 06, 2013 12:43 PM
To: Taylor Christopher - Nashville
Cc: oracle-l_at_freelists.org
Subject: Re: RAC Node Preference for sessions
Hi Chris,
Christopher.Taylor2_at_parallon.net schrieb:
> Is there a way to influence [thru manual intervention] which node is preferred for sessions?
> The reason I ask this question, in this way, is that we have 3 nodes, and node 2 continuously seems to be favored for new sessions.
Maybe the load balancing goals are of some interest for you: http://docs.oracle.com/cd/E11882_01/appdev.112/e25788/d_serv.htm#BABFDAEJ
Reagrds
Martin
-- Usn's IT Blog for Linux, Oracle, Asterisk http://www.usn-it.de -- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 06 2013 - 19:45:15 CET