ODP.NET

Hello,

I've been migrating an application originally designed for MS-SQL server. The application has the particularity of calling a great deal of stored procedures for every transaction. This application has been running in several production environments for a long time without any performance issues.

We had to migrate the application to Oracle 10G upon the requirement of one of our customers. We're using ODP.Net 10. Unfortunately the application started to run into performance issues. First we tough it had to do with database tuning but we found nothing wrong. Finally, i decided to put a sniffer between the application server and the database server. Comparing the former version (MSSQL) and the new one, I found out that there was a drastic difference in network traffic (Oracle traffic was 100 times greater). Because the application calls the same stored procedures many times, I concluded that the .Net Sql Client should be doing some sort of data caching in the client's side, because the calls don't actually go trough the wire.

I'd like to know whether the ODP.Client has the same feature or if a should implement it by myself.

I'd be very graceful for your answer.

Regards.
Bernabé