Wednesday, August 31, 2022

Script For Killing Long Running Queries Running From Specific Programs By Specific Users | Updated Version

 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

No comments:

Post a Comment