select sid, serial# from V$session
where sid in (select sid from v$LOCK where TYPE in ('TM','TX'));
alter system kill session 'sid, serial#';
select sid, serial# from V$session
where sid in (select sid from v$LOCK where TYPE in ('TM','TX'));
alter system kill session 'sid, serial#';