I am using ODP.Net 220.127.116.11 to connect my 32 bit Dot Net 2.0 windows application to Oracle 11g (Release 18.104.22.168.0 - 64 bit). The applications private working set memory kept on increasing and after few days the application crashes when private working set crosses 1 GB.
I am disposing reader, connection and command objects where ever I used, tried with 'using' also. I am using connection pooling in my application, when I don't use connection pooling I don't see much increase in private working set memory but it is badly affecting the performance.
Did any one had this problem? I will be much grateful for any insights on this problem.
No idea if this will help or not, but I've seen issues like this when running console applications where Main() is decorated with [STAThread]. The simplest solution is to change it to [MTAThread]. The problem is related to the garbage collector not actually getting to dispose of things properly. Some more info here: http://support.microsoft.com/kb/828988
If you're talking about a Forms application or something like that, this advise doesn't apply.