一次性kill -9
来源:互联网 发布:如何提高淘宝搜索流量 编辑:程序博客网 时间:2024/06/02 09:10
select f.PROGRAM, f.SID, f.STATUS, f.USERNAME, 'kill -9 ' || t.SPID
from v$process t, v$session f
where t.addr = f.PADDR
and f.sid in (SELECT sid
FROM v$lock t
WHERE (id1, id2, TYPE) IN
(SELECT id1, id2, TYPE FROM v$lock WHERE request > 0)
and t.REQUEST = 0)
and f.PROGRAM = 'JDBC Thin Client'
from v$process t, v$session f
where t.addr = f.PADDR
and f.sid in (SELECT sid
FROM v$lock t
WHERE (id1, id2, TYPE) IN
(SELECT id1, id2, TYPE FROM v$lock WHERE request > 0)
and t.REQUEST = 0)
and f.PROGRAM = 'JDBC Thin Client'
- 一次性kill -9
- kill和kill -9
- kill和kill -9
- kill和kill -9
- kill vs kill -9
- kill和kill -9
- kill和kill -9
- kill -9
- kill 9与kill -9
- Linux kill, killall, kill -9
- Linux kill, killall, kill -9
- Linux kill, killall, kill -9
- kill -9 can't kill
- Linux kill, killall, kill -9
- Linux kill, killall, kill -9
- Linux kill, killall, kill -9
- Linux kill, killall, kill -9
- Linux kill, killall, kill -9
- 阅读resyschina推荐引擎文章感受二
- 用pylint检查代码
- jquery 定义css样式
- lsof命令用法
- 浅析ETL中对日期的处理
- 一次性kill -9
- makefile
- 众多Android 开源项目推荐,给力工作给力学习
- org.slf4j.impl.StaticLoggerBinder.SINGLETON from class org.slf4j.LoggerFactory
- ETL 杂1
- ORACLE窗口函数over的使用
- 差距!!!
- Android矩阵原理详解(Matrix,ColorMatrix)
- IOException parsing XML document from class path resource [spring-jms-application.xml]; nested