alter system switch logfile;
select sid,process,program from v$session
where type='USER' and sid <> (select distinct sid from v$mystat);
kill these process!
alter system switch logfile;
select sid,process,program from v$session
where type='USER' and sid <> (select distinct sid from v$mystat);
kill these process!