I would like to know if someone know how to solve this problem. I’m using ORACLE and sometimes i have some stored procedures that stay frozen and they don’t die. So, if I call a new instance of the same procedure, This enter to the active queries tail.
To solve this problem I’d like to use some kind of timeout for the procedure. In rssql this characteristic is possible to configure.
I attach a screenshot showing the procedures that don’t run.