select 'alter system kill session'||''''||m.sid||','||sn.serial#||''''||';'
from v$session sn,v$lock m
where sn.sid=m.sid
and m.request=0 and lmode!=4
and (id1,id2) in
(select s.id1,s.id2 from v$lock s
where request!=0
and s.id1=m.id1
and s.id2=m.id2);
from v$session sn,v$lock m
where sn.sid=m.sid
and m.request=0 and lmode!=4
and (id1,id2) in
(select s.id1,s.id2 from v$lock s
where request!=0
and s.id1=m.id1
and s.id2=m.id2);