Originally posted by manjunathk

cursor c1 is
select 'alter system kill session ' ||

||to_char(a.sid)||','||to_char(a.serial#)||


from v$session a, v$lock b
where a.sid = b.sid
and b.lmode = 6 and
a.username like 'THE_BOREING_USER' and
b.ctime > time;


cursor c1 is
select 'alter system kill session = '''
||to_char(a.sid)||', '||to_char(a.serial#)||''' IMMEDIATE ;'
from v$session a, v$lock b
where a.sid = b.sid
and b.lmode = 6
and a.username like 'THE_BOREING_USER'
and b.ctime > time;

Sam