Re: Oracle 10g R2 RAC server side load balancing

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 ofOCI, then connections
> > made by the application cannot utilize server side load balancing.
>
> How do you use Pro*C and not useOCI?

Mr. Morgan it looks like your answer demonstrates complete ignorance of both Pro*C and OCI.

Pro*C does not generate calls to the Oracle Call Interface.

Have you coded in Pro*C before? Have you coded using OCI before?

To the OP oracle has good documentation in the OCI Call Interface Programmers Guide and the Oracle C++ Call Interface Programmers Guide. Received on Tue Jun 19 2007 - 06:36:59 CDT