oracle数据库java source编译hang住或loadjava jar包hang住处理步骤

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.