oracle最坑爹的地方：你insert update delete之后 或者kill死锁的时候记得一定要提交事务不然就是死锁卡在那里了
记住 kill死锁也是要提交事务的
select * from v$session where sid in (select session_id from v$locked_object) SELECT s.username,l.OBJECT_ID,l.SESSION_ID,s.SERIAL#,l.ORACLE_USERNAME,l.OS_USER_NAME,l.PROCESS FROM V$LOCKED_OBJECT l,V$SESSION S WHERE l.SESSION_ID=S.SID; alter system kill session ‘63,30893‘;
原文：http://www.cnblogs.com/liupengfei19940119/p/4565208.html