Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> killing sessions in v$session
select status, serial#, sid from v$session
get the sid, serial# from v$session
alter system kill session 'sid, serial#';
select status, serial#, sid from v$session but gives the status KILLED
I understand that it could be doing rolling back and it could take a long time. Hence, i will monitor again and replied later.
Cheers Received on Mon Aug 30 2004 - 23:13:19 CDT