Memory leak on Oracle server service

[info@apiasa.com]

Hello, maybe someone can help with this problem?
With our application using DOA 3.4.6.1 and Oracle 8.1.7 client we are experiencing strange memory problems (the Oracle server service memory continuously grow in several days until there's no memory left and Oracle crashes).
The code is clean (all objects freed up correctly, really nothing wrong, indeed the program itself does not eat memory).

To isolate the problem I did this: small program with TOracleSession component and TOracleDataset connected to a grid. When the application starts, with a loop I continuously refresh the query and in realtime I can see the server's memory growing....
As soon as I close the application the server's memory is freed and return to the original value: how is it possible? Any tips to find out the problem?
This occurs with both Oracle server 8.1.7 and 7.3.4.

thanks for your help!

Fulvio

 

[Eric^2]

Sounds like your DBA set the database up to not share any cursors and pin all sql statements in the cache. Talk to your DBA about this. Oracle's process should grow to the pre-specified size then stop growing.