event 10511 Prevent SMON from offlining idle Undo Segments
Prevent SMON from offlining idle Undo Segments using event 10511.
Set the following parameter in init.ora/spfile
event="10511 trace name context forever, level 2"
Then restart the database.
After the first onlinining of an Undo Segment, it will never be offlined and re-onlined.
So we will only get the "US" serialization once (on the first online after a db restart.)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/19015/viewspace-927887/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
关于rowcache的2个隐含参数
下一篇：
关于 kill session
请登录后发表评论
登录
全部评论
