View and kill sessions in Oracle

select
  sid||','||serial#,
  status,
  username,
  schemaname,
  machine,
  program,
  logon_time
from v$session
--where schemaname = 'SCHEMA_NAME'
--where lower(machine) like lower('computername%')
;

alter system kill session 'sid,serial#' immediate;

begin
  for s in (select sid,serial# from v$session where schemaname = 'SCHEMA-NAME')
  loop
    execute immediate 'alter system kill session '''
        || s.sid  || ',' || s.serial# || ''' immediate';
  end loop;
end;