Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Poor performance on WAN links

145643Mar 4 2009 — edited Mar 23 2009
Hi all.

I am working in to client/server real world applications, App1 is based on SQLServer and the App2 on Oracle (10gR2Linux x86 - RHEL).
I need to show that the applications work fine outside the LAN context, meaning that the applications can work on WAN links.

Both applications uses similar methods for data acess (ODBC - Bulk selects when possible, or cursor fetch). App1 is working fine when we move the client link to a WAN one, but App2 experience a huge drop of performance.

I do know that the underlying communication protocol (SQL*NET vs DBLib) has distinct implementations, and that the number of control packets of SQL*Net is much higher than DBLib.

Is there a way to configure SQL*NET or ODBC in order to minimize the number of Round Trips or Control Packets?
What else should I investigate?

Thanks in advance!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 20 2009
Added on Mar 4 2009
8 comments
4,224 views