This content has been marked as final. Show 2 replies
set heading off
select 'ALTER SYSTEM KILL SESSION '''||sid||','||serial#||''';' From v$session where username='NAME OF USER';
Edited by: Niket Kumar on Dec 6, 2012 3:09 PM
Actually I want to kill sessions which are running a select statement for more than two hours - session beloning to a given user.