SELECT SADDR,SID,SERIAL#,PADDR,USERNAME,STATUS FROM V$SESSION WHERE USERNAME IS NOT NULL;
alter system kill session 'sid,serial#' immediate;
SELECT SADDR,SID,SERIAL#,PADDR,USERNAME,STATUS FROM V$SESSION WHERE USERNAME IS NOT NULL;
alter system kill session 'sid,serial#' immediate;