The script will dynamically generate SQL when required to kill more sessions that will fit your predicate search. select 'alter system kill session ''' || u.sid || ',' || u.serial# || ''';' from v$session u where u.type = 'USER' and u.module like '%<module>%;
select 'alter system kill session ''' || u.sid || ',' || u.serial# || ''';' from v$session u where u.type = 'USER' and u.module like '%<module>%;