ora-00054:resource busy and acquire with nowait specified
来源:互联网 发布:数据统计业务员业绩表 编辑:程序博客网 时间:2024/05/24 04:33
1.查到SID.SELECT SESSION_ID FROM V$LOCKED_OBJECT,USER_OBJECTS WHERE V$LOCKED_OBJECT.OBJECT_ID=USER_OBJECTS.OBJECT_ID ;
2.查到SERIAL#.SELECT SERIAL# FROM V$SESSION WHERE SID=‘SESSION_ID’ ,
3.alter system kill session 'sid,SERIAL#'
报错:ERROR at line 1:
ORA-00031: session marked for kill
4.select spid, osuser, s.program from v$session s,v$process p where s.paddr=p.addr and s.sid=24
切换ROOT用户
kill -9 spid
但错误仍然有。
结果是有个JOB在执行。
- ora-00054:resource busy and acquire with nowait specified解决方法
- ora-00054:resource busy and acquire with nowait specified解决方法
- ora-00054:resource busy and acquire with nowait specified解决方法
- Ora-00054 resource busy and acquire with nowait specified
- Ora-00054 resource busy and acquire with nowait specified
- ora-00054:resource busy and acquire with nowait specified解决方法
- ora-00054:resource busy and acquire with nowait specified解决方法
- oracle ora-00054:resource busy and acquire with nowait specified
- ORA-00054: resource busy and acquire with NOWAIT specified
- ORA-00054:resource busy and acquire with nowait specified
- ORA-00054:resource busy and acquire with NOWAIT specified
- ora-00054:resource busy and acquire with nowait specified解决方法
- ora-00054:resource busy and acquire with nowait specified解决方法
- ORA-00054: resource busy and acquire with NOWAIT specified
- ora-00054:resource busy and acquire with nowait specified解决方法
- ORA-00054 resource busy and acquire with NOWAIT specified
- ora-00054:resource busy and acquire with nowait specified解决方法
- ORA-00054:resource busy and acquire with NOWAIT specified
- (C++设计模式) ------原始模型模式 Prototype -- 创建型模式
- linux关于bashrc与profile的区别
- ioremap 和 phys_to_virt区别
- MVC HtmlHelper说明
- 清除mysql表中数据
- ora-00054:resource busy and acquire with nowait specified
- 人性的弱点的自我窥视
- android SD卡路径问题以及如何获取SDCard 内存 (转)
- 黑马程序员——文件复制时间
- 自定义 Preference Header 布局
- Yii弹出窗口组件CJuiDialog
- Jquery + Bootstrap 做的一个Expander Grid
- hibernate中session的三种状态
- AfxBeginThread,_beginthreadex与CreateThread的关系