oracle常见错误_ORA-00060：等待资源时检测到死锁

oracle执行语句时长时间无响应，很大可能就是出现锁表

1、查看是哪个表被锁了

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;

2、杀掉锁表进程

根据查询出来的sid和serial#值杀掉对应进程

alter system kill session '4547,5231';   --分别为SID和SERIAL#