进来操作Oracle老是出现死锁现象,可能自己太菜鸟,也可能oracle太强鸟。经常麻烦DBA她会恨我滴-。-#
有需要的那去吧:)

 

检查那个表被锁

1
2
3
4
select sess.sid,sess.serial#, lo.oracle_username,lo.os_user_name,ao.object_name,lo.locked_mode
from v$locked_object lo,dba_objects ao,v$session sess
where ao.object_id = lo.object_id
and lo.session_id = sess.sid;

alter system kill session '285,13';  干掉……