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#...
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