1.查出对象
select object_name, object_type, t.*
from dba_objects t
where object_name like '%HttpClientBuilder%'
2.查看v$DB_OBJECT_CACHE中此对象是否被pin 住和锁的模式
select *
from v$DB_OBJECT_CACHE t
where t.NAME = '/c20f5752_HttpClientBuilder'
and t.LOCKS != '0'
3.找对应的sid
select * from v$access t where t.OBJECT = '/c20f5752_HttpClientBuilder'
4.找进程Id
select spid
from v$process
where addr in (select paddr from v$session where sid = 93)
5.kill -9 进程id
6.查找session_id
select * from dba_ddl_locks where owner = 'UAT2'
7.查找pid
select * from v$session t where t.SID in(2508,596)
可将第6步查出的session_id代入第4步得到spid,登陆服务器kill.
分享到:
相关推荐
oracle完整引入jar包和编译java类,实现数据库级别的函数的调用
个人亲测oracle触发器调用java程序
本资源实现的一个用java代码实现数据二维码图片的生成,用触发器实现将生成的二维码图中转换成blob格式并插入到数据表中
Java以及tomcat的安装和环境变量的配置
file_manager.sqlJava Layer TraceFileDisplay.java you need to compile this and use loadjava to deploy it into the TFMADMIN account sample compilation & load - see javacomp.txt test the Java layer - ...
SQL/Oracle/MySQL Driver整合