In our company we use a lot of Oracle, and after the release of the managed provider we migrated all applications to it. First the things were very impressive : the new client was faster, but after some days applications that uses 100MB with old client goes to 1GB and up. The memory is not the only issue, we use a lot of multi threading, and we experience connection drops and not disposal, after 1 days working one of the application had over 100 sessions on the server. I think there is something wrong with connection pool and multi threading.
Is someone experience same problems.
Yesterday we went back with unmanaged provider. Now things are back to normal.
Talking about this issue a bit more with my dev team, I'd like to send you some instructions for collecting dump information. With the generated dumps, the ODP.NET dev team can debug and fix the issue in a bug fix so that you can continue using managed ODP.NET. Please email dotnet_us (at) oracle.com and we'll send you info on how to collect the dumps.
connection drops: did you try to use "Validate Connection=true" parameter in your connection string?
the new client was faster: are you sure with this statement? Even in 64bit environment? I got quite serious performance problems when running application under 64bit process: https://forums.oracle.com/thread/2595323