原文出处:
http://www.itpub.net/29477,2.html
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.
我对下面这两句狂怀疑:
but sniped sessions never get cleaned up.
but still is never cleaned up.
难道如果设置了resource_limit = true, and idle_time in profile,又没有通过kill -9 os层面来杀,session量就会只增不减,直到超过最大并发数?pman真的不管sniped 和killed 的sessions?
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.
我对下面这两句狂怀疑:
but sniped sessions never get cleaned up.
but still is never cleaned up.
难道如果设置了resource_limit = true, and idle_time in profile,又没有通过kill -9 os层面来杀,session量就会只增不减,直到超过最大并发数?pman真的不管sniped 和killed 的sessions?
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/310745/viewspace-6308/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/310745/viewspace-6308/