oracle 操作表时没及时提交事务造成死锁问题

oracle 操作表时没及时提交事务造成死锁问题，解决方案如下：

– 查死锁
select session_id from v$locked_object;

– 查SERIAL

select * from v$session where session_id = ‘’;

– 杀死锁

alter system kill session ‘sid,#SERIAL’