I am using .Net Framework 4.7.2, oracle server 19c and Oracle.ManagedDataAccess 23.7.
My App has 2 part:
-
5 async tasks to open connection for every 0.5s and query the database (query only) then close it (by ‘using’) and the connection string is: User Id=username; Password=pw; Data Source=IpAddr/sid; Min Pool Size=10;
-
2 async tasks to open connection on demand (may be every 0.5s) and query the database (query only) then close it (by ‘using’) and the connection string is: User Id=username; Password=pw; Data Source=IpAddr/sid; Min Pool Size=5;
The problem is: after several hours running, some times, it takes rather long time than expected to open a connection: normally is 100-200ms, worst is 5-10s or more!
Normally, query will take < 100ms, worst is 500ms.
Db server is at good status, other modules using Devart Express are running just fine!
Please help!