-- Run as SYS
SELECT s.sid,s.serial#,ps.spid "OS PID", 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')
/
Kill OS Thread (c:\ orakill )
e.g. orakill DB1 3026
全站熱搜
留言列表
{{ article.title }}