Oracle ODBC generating excessive network traffic
925505Mar 22 2012 — edited May 18 2012I'm trying to track down why reports from my WebApp are running so slow when connected to Oracle and I've discoverd that there is an unusually high amount of TCP/IP traffic between the Web Server and the Oracle Server as the report is being generated. When I connect my WebApp to SQL Server version of the database the reports run very fast.
Using a Process Monitor I discovered that, when Connected to Oracle, a report that returns zero (0) rows generates 2,671 TCP/IP packets between IIS and the Oracle server, and it takes 16 seconds to generate the report. If I run the same report, but connected to SQL Server, there are only 35 TCP/IP packets and the report runs in less than 2 seconds.
Is there some ODBC or Oracle configuration that I'm missing which is causing the excessive TCP/IP packets?
Oracle Driver: 11g ( SQORA32.DLL ) version 11.02.00.03 dated 10/30/2011.
Database: Oracle 11g
Web Server: Windows Server 2008 32bit with IIS7
Update: It is not just the reports. The entire application is slow when connected to Oracle. I connected my WebApps to a SQL Server version of my database and compared performance and captured TCP/IP traffic. When connected to Oracle there 1000% increase in TCP/IP traffic compared to SQL Server.
What could be causing Oracle and IIS to need to exchange so many TCP/IP packets as opposed to IIS and SQL Server?
Jerry