In our .net framework 2.0 based application we were using System.Data.Oracleclient and now migrating to ODP.Net, the volume of the project is too high,so we cannot do the entire migration on one go, as a result the application is using 2 providers System.Data.Oracleclient & ODP.Net as of now.Now we are changing our OS, from Windows xp 32bit to Windows 7 64bit. While doing so we observed the following,1) A query executes in < 1 sec using System.Data.Oracleclient & ODP.Net 10g 64bit (Oracle.DataAccess.dll version 2.102.2.20).and the same query executes in < 1 sec on Oracle SQL Developer v1.5.2) However the same query is taking 2-3 mins to execute using System.Data.OracleClient with ODP.Net 11g 64bit (Oracle.DataAccess.dll version 2.112.3.0).we found a remarkable performance degradation in point 2),we have to use System.Data.OracleClient with ODP.Net 11g 64bit (Oracle.DataAccess.dll version 2.112.3.0) on Windows 7 64bit OS,but we cannot live with the performance degradation as mentioned in point 2),and we cannot convert all code which uses System.Data.OracleClient to ODP.Net very quickly.So can anyone help us, on why do we see such remarkable performance degradation as mentioned in point 2), and what do we do to resolve this problem.RegardsSanjib Harchowdhury 解决方案 please refer this link, or just replace ODP.Net 64bit component with ODP.Net 32bit, as we are using asp.net we could easily configure our application to run using the 32bit component in Windows 7 (x64) edition. 这篇关于.net 2.0网站中一起使用的System.Data.OracleClient和ODP.Net 11g的问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持! 上岸,阿里云!