SQL Script to Kill Oracle Database sessions

Instructions.md

In order to kill database sessions, run the following scripts in SQL *Plus and then exit.

Replace SCHEMA_NAME with the name of your schema.

declare
  cursor c1 is
  SELECT s.sid, s.serial# as serial
  FROM v$session s, v$process p
  WHERE s.username = 'SCHEMA_NAME'
  AND p.addr(+) = s.paddr;
begin
  for rec in c1 loop
    execute immediate 'Alter System Kill Session '''|| rec.Sid
           || ',' || rec.Serial|| ''' IMMEDIATE';
  end loop;
end;
/