rasti.hil@hilandco.com +41 79 367-9677

Thursday, 11 March 2010

Ora-01940 how to kill session


select s.sid, s.serial#, s.status, p.spid
from v$session s, v$process p
where upper(s.username) = upper('USERNAME')
and p.addr (+) = s.paddr;

alter system kill session '<s.sid>,<s.serial#>';

No comments: