寻找 library cache lock 等待事件的session
library cache lock
select * from v$session_wait where event<>'SQL*Net message from client'
在v$session_wait 里查到library cache lock 的saddr,将saddr传给下一个查询的kgllkses
select kgllkses saddr,kgllkhdl handle,kgllkmod mod,kglnaobj object
from x$kgllk lock_a
where kgllkmod > 0
and exists (select lock_b.kgllkhdl from x$kgllk lock_b
where kgllkses = '0700000A877A66D8' /* blocked session */
and lock_a.kgllkhdl = lock_b.kgllkhdl
and kgllkreq > 0);
查处具体的saddr到v$session视图查出sid和serial#并杀之
select * from v$session where saddr='0700000A87814228'
alter system kill session '2720,41211'
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/16400082/viewspace-746344/ ，如需转载，请注明出处，否则将追究法律责任。
