ejhayes · August 26, 2010 21:41
diff --git a/findAndTerminateSessions.sql b/findAndTerminateSessions.sql
 select s.sid, s.serial#, s.status, p.spid 
 from v$session s, v$process p 
 where s.username = 'myuser' 
 and p.addr (+) = s.paddr;

 -- alter system kill session '<sid>,<serial#>';
	select s.sid, s.serial#, s.status, p.spid
	from v$session s, v$process p
	where s.username = 'myuser'
	and p.addr (+) = s.paddr;

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