Re: Oracle 10g R2 RAC server side load balancing

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 17 Jun 2007 11:58:19 -0700
Message-ID: <1182106697.567125@bubbleator.drizzle.com>

zigzagdna_at_yahoo.com wrote:

> On Jun 17, 2:41 pm, DA Morgan <damor..._at_psoug.org> wrote:

>> zigzag..._at_yahoo.com wrote:
>>> I am on Windows 2003 server.
>>> In Oracle 10g r2, Oracle provides a load balancing advisory to
>>> distribute load
>>> among various noads when connections are made, i.e., a connection may
>>> be made
>>> to least loaded node. Oracle documentation also says somewhere that
>>> this feature is only available with clients which use ODP.NET, JDBC,
>>> OCI.
>>> 1. If my application is using PRO*C instead of OCI, then connections
>>> made by the application cannot utilize server side load balancing.
>> How do you use Pro*C and not use OCI?
>>
>>> 2. Is it correct that my application code will not require any
>>> changes to take advantage of this feature?
>> Depends on whether your application is coded properly: We don't know.
>> --
>> Daniel A. Morgan
>> University of Washington
>> damor..._at_x.washington.edu (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org

> 
> 1. PRO*C is PRO*C - not sure whether Oracle pre-compiles it into OCI
> calls.

Are you seriously going to state that you wrote code in a tool without determining what that tool is and does? April first was two months ago. I thought it was only VB programmers that did that.

> 2. What do you mean applicaion is coded properly. I did not see > anywwhere information that code has to be written in a certain way.

Not to be harsh but given your response to #1, above, I am not surprised.

> I am not utilizing TAF or OFN (?) events, simily making database
> connections ... I will  think that one should not require any code
> changes at all.

OFN? Do you mean FCF or ONS? Either way load balancing is done at the listener layer. Failover is done by TAF and FCF.

I am totally perplexed that anyone let you near an Oracle RAC cluster with a tool like Pro*C and not a byte of understanding of what it is you are messing with.

Did your CTO make a bet on whether Oracle is unbreakable?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Sun Jun 17 2007 - 13:58:19 CDT