oracle – generate kill database sessions script

By Ravi Karamsetty | July 21, 2016 |

Here is the script that comes handy to Oracle DBAs for generating script to kill sessions based on user sessions. For example, this SQL script generates the script to kill all the sessions belong to user – SCOTT. Login to database as sys or system or sysdba or user with DBA role: SQL> select ‘alter … Continue reading “oracle – generate kill database sessions script”

Read More