ora-00054:resource busy and acquire with NOWAIT specified
and with specified resource ORA Busy acquire nowait
2023-09-14 09:01:12 时间
解决办法:
查询锁表情况:
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命令一起使用;
相关文章
- [Android Pro] AAR and JAR
- CareerCup-BASE CASE AND BUILD
- Creating PDF Reports with Pandas, Jinja and WeasyPrint
- Job for docker.service failed because the control process exited with error code. See "systemctl status docker.service" and "journalctl -xe" for details.
- [Serverless CLI + AWS] Get started with Serverless and AWS lambda
- [React] Performance: Split state update and component render with Hoc
- [CSS 3] Center an element both horizontally and vertically with place-items CSS property
- [React Testing] Test a Custom React Hook with React’s Act Utility and a Test Component
- [Transducer] Make an Into Helper to Remove Boilerplate and Simplify our Transduce API
- [Vue] Preload Data using Promises with Vue.js and Nuxt.js
- [Vue] Build Vue.js Apps with the Vue-CLI and Nuxt.js
- [React] Preventing extra re-rendering with function component by using React.memo and useCallback
- [Node.js] Using ES6 and beyond with Node.js
- atitit.Atitit. Gui控件and面板-----服务端控件 java struts的实现最佳实践
- 【poj 1704】Georgia and Bob
- 加载数据集(Dataset and DataLoader)
- Building real-time dashboard applications with Apache Flink, Elasticsearch, and Kibana
- 【文献学习】1 Power of Deep Learning for Channel Estimation and Signal Detection in OFDM