ODP .NET memory consumption with IIS Server
Hello,
We are running a ASP .NET application with ODP .NET to access back-end data with IIS 6.0 as the web server.
What we have noticed is, the Oracle DLL/libraries seems to allocate memory in the IIS worker process but does not free them. This in turn increases the amount of memory the worker process uses(in direct relationship to the number of users connected to the web application). The only way the memory is freed is by re-starting the IIS web server and sometimes the worker process becomes non-responsive too (around 250MB).
What I assure is, whenever the ASP .NET application needs data from the database, it opens a connection, reads the data and then closes the connection. I believe closing the database connection should free the memory used within the worker process?
The ODP .NET version we use is 2.102.2.20.
Can anyone please share there insights or suggestions on resolving such scenarios?
Appreciate your time and help.