OraDirect Memory Leak

OraDirect Memory Leak

Postby John » Thu 21 Apr 2005 16:14

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
John
 
Posts: 25
Joined: Fri 12 Nov 2004 21:18
Location: Durham, NC, USA

Postby Paul » Fri 22 Apr 2005 08:55

What SQL statement do you execute? Possibly this happens with particular field
types. What is the type of fields in your table?
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06

OraDirect Memory Leak

Postby John » Fri 22 Apr 2005 14:36

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
John
 
Posts: 25
Joined: Fri 12 Nov 2004 21:18
Location: Durham, NC, USA

OraDirect Memory Leak

Postby John » Fri 22 Apr 2005 14:38

Also, what field types specifically do you suspect may cause a memory leak?
John
 
Posts: 25
Joined: Fri 12 Nov 2004 21:18
Location: Durham, NC, USA

Hi - Out of Memory

Postby nmuralidhar » Mon 15 Aug 2005 18:06

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.
nmuralidhar
 

Postby Paul » Tue 16 Aug 2005 06:34

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
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Memory issue

Postby nmuralidhar » Tue 16 Aug 2005 14:59

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
nmuralidhar
 

Memory issue

Postby nmuralidhar » Tue 16 Aug 2005 19:08

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.
nmuralidhar
 


Return to dotConnect for Oracle