ora-00054:resource busy and acquire with NOWAIT specified
解决办法:
查询锁表情况:
select o.object_name, machine, s.action,s.TERMINAL, s.sid, s.serial# from v$locked_object l, dba_objects o, v$session s
where l.object_id= o.object_id and l.session_id = s.sid;
强制解锁:
alter system kill session '1020,16863'; -- (分别是上面查询出的sid,serial#)
select o.object_name, machine, s.action,s.TERMINAL, s.sid, s.serial# from v$locked_object l, dba_objects o, v$session s
where l.object_id= o.object_id and l.session_id = s.sid;
强制解锁:
alter system kill session '1020,16863'; -- (分别是上面查询出的sid,serial#)
问题表现形式:数据insert和delete一直在执行,无法成功,数据库卡死
问题原因分析:
对oracle的表进行更新操作(插入、删除)后,未进行commit提交所致;
问题规避方法:
对oracle的表进行更新操作(插入、删除)后,及时进行commit提交,即insert和delete命令要配合commit命令一起使用;