Asp.net Oracle Tuning Thread Sleep
I have a website in ASP.NET MVC 4. This site stores data in an Oracle database. The version of my Oracle.DataAcess.dll is 4.112.3.0 (runtime version: 4.0.30319). Below is information about the database executing the following command: 'select * from v $ version';
Ok, I am profiling my website with Jet Brain Dot Trace. In my snapshot, they show me that the two methods in "Oracle.DataAcess.Client.OracleTuningAgent" are consuming more CPU time. These methods are "Oracle.DataAcess.Client.OracleTuningAgent.DoScan" and "Oracle.DataAcess.Client.OracleTuningAgent.DoWait". Alternatively, call the "System.Threading.Thread.Sleep" method. Below, snapshot information:
I tried adding "Self Tuning = false" to the connection string, but they only stop to call the DoWait function and continue to call the DoScan function.
Is there a way to disable these functions for calling? Or is it not a good idea?
Obs: Sorry for the bad english, actually I am using google translator to help me write this question.
source to share
Phelps.
In my case, I increase the maximum pool size until there is an error. like this. "Maximum pool size = 250;"
At the end of the day, I am trying to figure out how many connections my application needs. Also you need to configure your connectionString example) Minimum / Maximum Pool Size Incr / Decr Pool Size.
as below is my comment.
Actually my problem is caused by the lack of oracle connections. Because I didn't call "close ()" after the completion request.
If you have permission, find the v $ session table. you can see the growing number of sessions. your every function works after.
but if you don't have permission you can use netstat -an. with findstr / c: 1521
source to share