Problem Description
——————-If “init.ora” resource_limit = true, and idle_time set in profile.
When idle_time exceeds, the session status becomes ’sniped’ in v$session,
but sniped sessions never get cleaned up.
Using ‘alter system kill session’ to kill the session, session status becomes
‘killed’ in v$session, but still is never cleaned up.
(全文…)
1 Library Cache Pin/Lock Pile Up
SELECT s.sid, kglpnmod “Mode”, kglpnreq “Req”, SPID “OS Process”
FROM v$session_wait w, x$kglpn p, v$session s ,v$process o
WHERE p.kglpnuse=s.saddr
AND kglpnhdl=w.p1raw
and w.event like ‘%library cache pin%’
and s.paddr=o.addr
(全文…)
telnet aix140.vicp.net 或 telnet aix140.meibu.com
用户名：test01 到 test09
密码： test01 到 test09
CopyRight ©2007 oralife.cn, All rights reserved.
联系站长bosonmaster(at)gmail.com|QQ联系:859358
Powered by WordPress
京ICP备07026883号
