Find and destroy Oracle TX locks

select username, SYS.v_$lock.sid,lmode,request from SYS.v_$lock,SYS.v_$session
where SYS.v_$lock.type='TX'and SYS.v_$lock.sid=SYS.v_$session.sid;
select serial# from SYS.v_$session where SID = '336'
alter system kill session '336,7263'