Просто замените username на те, что нужны.
Just change username in section…
SELECT 'KILLING SESSION of LOUISE' FROM DUAL;
BEGIN
FOR r IN (select sid,serial# from v$session where username in ('LOUISE','MAM','PBB') )
LOOP
EXECUTE IMMEDIATE 'alter system kill session ''' || r.sid
|| ',' || r.serial# || '''';
END LOOP;
END;
/
Don’t forget to use upper case : UPPER(‘username’)