On Apr 21, 2018 I've published a shell script to kill long-running sessions in Oracle DB connecting from specific MODULES and running longer than x number of minutes. I've revisited the script, adding more handy features, and make it compatible with 12c+ versions.
Here is a sum of all features:
Under the following section, you can tweak the script settings and define the killing criteria :
Detailed description of script parameters you can tweak:
Here is the GitHub version of the script: [You can copy the content below]
https://gist.github.com/0aa26dee2de1005715d3d8ac01dddee0.git
