we have a web application ( ASP.Net 4.0, dotconnect 6.10.135, oracle client 10g, IIS7, Windows Server 2008) that hangs frequently in production (~300 concurrent users).
At least once a day, the application stops responding, and we see errors in eventlog or our own trace log like:
orMessage: Server did not respond within the specified timeout interval
StackTrace - at Devart.Data.Oracle.az.a(y A_0, a2 A_1)
We suspected this to be a connection pool problem, but increasing the pool to 300 did not help.Exception message: The underlying provider failed on Open
We tried to monitor the connections with dbMonitor. This tool shows that connections onlx go up to ~ 20, but does no longer connect to the application after some time ( dbMonitor restarted or not ) and shows nothing e.g. the next day, so we do not know the value in case of the hang.
The team that runs the oracle db says that the db side shows nothing in the case of our hang, no anomalies, no LOCKS.
And, of course, it does not happen at our test systems.
Setting the Connection Timout to 120 did not change anything. Maybe because its only for direct mode, which we do not use.
This problem onls exists since we moved to .NET 4 with our application, the database and the db client remained the same, only Framework and devart provider changed.
Do you have any idea what to check or what to do, to identify the real reason of this problem?
Any help would be appreciated.