You can kill all connections by running the code below. Just Replace SCHEMA with your schema name.
declare str varchar2(100);
begin
for SES in (select sid,serial# from v$session where username='SCHEMA' )
loop
str := 'alter system disconnect session '|| '''' || to_char(SES.sid) ||','||to_char(SES.serial#)||'''' || ' ' || 'immediate';
execute immediate str;
end loop;
end;
To kill a single connection, first find the connection by running:
select * from v$session;
Then run:
alter system kill session 'sid,serial#';
where sid and serial# are extracted from your first query of v$session above.
