This content has been marked as final. Show 2 replies
I have similar issue on Win 7 64 bit and ODP 126.96.36.199 with .Net 4.0.
Running my program with Oracle.DataAccess takes 1.30 minutes
With MS Oracle client - 20 seconds
What is the reason?
Just a guess, but what have you set as the value for the "enlist" connection parameter (it defaults to true)? If possible you may try setting to "false" and verify. Also, it might be worth investigating the FetchSize value if there are lots of roundtrips due to small value.