Hello everyone, hope everything is fine.
I have a situation here where one database we connect via dblink became unresponsive (its operating system froze, according to the guy responsible), but was still accepting incoming connections. This resulted in sessions that were stuck, running indefinitely (they would not die after a "kill session" either, I had to log into the operating system and kill -9 the appropriate process manually). With this, the number of open sessions in our own database skyrocketed (thanks to apps that accessed the problematic dblink), hit the process limit and crashed our database.
Considering this scenario, what would you guys recommend, to avoid this kind of issue in the future? My first thought was to set up a timeout of sorts to queries done via dblink, but I can't find any way to do this.
My Db version is 11.2.0.4.
Thanks!