Select s.username,s.sid, s.serial#, p.spid, s.client_info,s.STATUS from v$process p, v$session s
where p.addr = s.paddr ;
kill -9 spid
alter system kill session 'sid,serial#';
Select s.username,s.sid, s.serial#, p.spid, s.client_info,s.STATUS from v$process p, v$session s
where p.addr = s.paddr ;
kill -9 spid
alter system kill session 'sid,serial#';