oracle – generate kill database sessions script

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 […]