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]

No comments:

Post a Comment