Monday 11 May 2015

KILL Specific Sessions in Oracle :

column machine format a21
column username format a8
select user#,machine,username,SID,serial#,status from v$session;
ALTER SYSTEM KILL SESSION '9,141';

where '9' is the SID and '141' is the serial#...

No comments:

Post a Comment