ora-00031:session marked for kill(标记要终止的会话)解决方法
来源:互联网 发布:淘宝网天猫女装秋装 编辑:程序博客网 时间:2024/05/09 22:42
今天碰到一个问题,有一张表不能操作,很可能是被锁了,首先想到的是kill session,于是执行了下列的脚本找到是哪个session有问题:
select object_name, machine, 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;
发现有一个会话有锁sid 197,serial# 17,于是执行alter system kill session ‘197,17’;大概等了30s中,pl/sql developer报出一个错误:ora-00031:标记要终止的会话。
解决方法:查出session的spid
select spid, osuser, s.program
from v$session s, v$process p
where s.paddr = p.addr
and s.sid =197;
1. 在linux上, kill -9 12345
2. 在windows上,C:\Documents and Settings\gg>orakill orcl 12345
orcl:表示要杀死的进程属于的实例名
12345:是要杀掉的线程号
ORA-00031: session marked for kill
Cause: The session specified in an ALTER SYSTEM KILL SESSION command cannot bekilled immediately (because it is rolling back or blocked on a networkoperation), but it has been marked for kill. This means it will be killed as soonas possible after its current uninterruptible operation is done.
Action: No action is required for the session to be killed, but further executionsof the ALTER SYSTEM KILL SESSION command on this session may cause the sessionto be killed sooner.
- ora-00031:session marked for kill(标记要终止的会话)解决方法
- ora-00031:session marked for kill(标记要终止的会话)解决方法
- ORA-00031:标记要终止的会话 解决方法
- ora-00031:标记要终止的会话解决方案
- ORA-00031: session marked for kill 处理Oracle中杀不掉的锁
- ORA-00031: session marked for kill 处理Oracle中杀不掉的锁
- ORA-00031: session marked for kill 处理Oracle中杀不掉的锁
- ORA-00031: session marked for kill 处理Oracle中杀不掉的锁
- ORA-00031: session marked for kill 处理Oracle中杀不掉的锁
- ORA-00031: session marked for kill 处理Oracle中杀不掉的锁
- ORA-00031: session marked for kill 处理Oracle中杀不掉的锁
- ora-00031:session marked for kill处理oracle中杀不掉的锁
- ora-00031:session marked for kill处理oracle中杀不掉的锁
- ora-00031:session marked for kill处理oracle中杀不掉的锁
- ora-00031:session marked for kill处理oracle中杀不掉的锁
- ora-00031:session marked for kill处理oracle中杀不掉的锁
- ora-00031:session marked for kill处理oracle中杀不掉的锁
- ora-00031:session marked for kill处理oracle中杀不掉的锁
- IE 条件解释的语句
- 用谷歌搜索遇到“无法显示此网页”时怎么办?
- ios 版本比较
- Hibernate笔记
- SendMessage是否投递到消息队列
- ora-00031:session marked for kill(标记要终止的会话)解决方法
- c#获取系统日期,星期几
- 经典sql语句
- 学习AIX-lsattr、lsps命令备忘
- JavaScript学习笔记(03)之JavaScript如何输出显示
- 关于C++随机数生成中种子值设置的一点总结,解决随机数序列重复问题
- JS截取字符串substr 和 substring方法的区别
- loadrunner录制时,IE死掉
- SIP Using SDP with Offer/Answer Model