Page 1 of 1

OraDirect Memory Leak

Posted: Thu 21 Apr 2005 16:14
by John
We are having trouble with our application consuming large amounts of RAM (hundreds of megabytes) and eventually crashing with an "out of memory" error. Suspecting a memory leak we used Compuware’s DevPartner tools to analyze the memory usage. What we found was the the memory was not being leaked from our code but from the calls to OraDirect. Specifically, the trouble seems to be with the PrepareCommand (accounting for 28.8% of the problem) and the DataAdapter.Fill(DataSet) (accounting for 71.2% of the problem) method calls.

Has anyone else experienced memory issues with OraDirect?
Is there anything we can do (form our application) to help?
Are there changes coming in v3.0 that may help?

[Note we experience the same problem with v3.0 beta.]

Thanks!


John

Posted: Fri 22 Apr 2005 08:55
by Paul
What SQL statement do you execute? Possibly this happens with particular field
types. What is the type of fields in your table?

OraDirect Memory Leak

Posted: Fri 22 Apr 2005 14:36
by John
Hi Paul;

Our application is calling an Oracle 8i stored procedure. The stored procedure takes objects as input parameters and returns ref cursors that are used to fill a typed dataset. The objects and ref cursors themselves contain a mix of various primitive types including e.g. decimal, string etc. Note the Compuware DevPartner tool shows that the memory being leaked in our application is of type byte[]. Please let me know if you need further clarification. Are there any known specific situations where OraDirect will leak memory? If so please let us know so we can try to identify and avoid these situations.

Thank you!


John

OraDirect Memory Leak

Posted: Fri 22 Apr 2005 14:38
by John
Also, what field types specifically do you suspect may cause a memory leak?

Hi - Out of Memory

Posted: Mon 15 Aug 2005 18:06
by nmuralidhar
Did you find any solution to your probem. Even we are having similar problems and I want to resolve this issue as soon as possible.

Thanks.

Posted: Tue 16 Aug 2005 06:34
by Paul
We fixed two memory bugs in OraDirect 2.50.3. Please check OraDirect .NET 3.01.2, it is more stable now. We fixed memory leaks with LONG parameters.
Send us please small demo project to demonstrate your problem and include script to create server objects. Please specify version of OraDirect .NET, Oracle client, Oracle server

Memory issue

Posted: Tue 16 Aug 2005 14:59
by nmuralidhar
Thanks for the reply Paul.

The problem is we are not having this memory issue on our machines but 90% of the users are having this issue. I am using OraDirect 2.01 with .NET framework 1.1.

Is the upgrate a free download ?
Paul wrote:We fixed two memory bugs in OraDirect 2.50.3. Please check OraDirect .NET 3.01.2, it is more stable now. We fixed memory leaks with LONG parameters.
Send us please small demo project to demonstrate your problem and include script to create server objects. Please specify version of OraDirect .NET, Oracle client, Oracle server

Memory issue

Posted: Tue 16 Aug 2005 19:08
by nmuralidhar
Hi Again,

I went ahead and installed the 2.5x version of OraDirect.Net.

Now I am not getting back records in one of the procedure calls which I was getting earlier. I know you want some DEMO project for you. But did anyone have this issue, I am really running short of time here and any suggestion is appreciated.

Thanks.