close
-- Run as sys
Diagnose Library Cache Pin Wait:
SELECT s.sid,s.serial#,ps.spid "SPID", p.kglpnmod "Mode", p.kglpnreq "Req"
FROM x$kglpn p, v$session s ,v$process ps
WHERE p.kglpnuse=s.saddr
AND ps.addr = s.paddr
AND p.kglpnmod 0
AND p.kglpnhdl in
(select p1raw from v$session_wait where event = 'library cache pin');
Remedy:
Under Windows:
orakill SPID>
Under Linux:
kill -9 SPID>
全站熱搜
留言列表
{{ article.title }}