了解Maclean Liu|向Maclean Liu提问 Oracle ALLSTARS 全明星(群内有多位Oracle高级售后support,N位OCM和ACE) QQ群 # QQ群号:23549328 # 已经升级到 2000人群,空位多多。欢迎有一定基础的Oracle骨友加入,现在入群需要经过Maclean的技术面试,欢迎面试,请加QQ号:47079569 为好友参加面试 2群基础群 适合刚入门的同学,会共享最佳入门实践和资料 QQ群 # QQ群号:171092051 # 已经升级到 500人的超级群,空位多多,无需面试

EVENT:10052 "Stop SMON from cleaning up obj$"

Text:   Stop SMON from cleaning up obj$ ------------------------------------------------------------------------------- NOTE: Events should NEVER be set by customers unless advised to do so by Oracle Support Services. You must read <Note:75713.1> before setting ANY event on a system. Usage: ~~~~~~ To disable cleanup of OBJ$ by SMON set this event in the init.ora file thus: EVENT="10052 trace name context forever" Explanation: ~~~~~~~~~~~~ Setting event 10052 stops SMON trying to clean up OBJ$. The implication of this is that OBJ$ will grow with entries for non-existent objects, eg: objects which have been dropped and object entries created for negative dependency reasons. The usual reason for setting this event is to prevent SMON from crashing / spinning in the OBJ$ cleanup code whilst diagnostics or further investigations are performed. It is also sometimes used in Parallel Server environments so that OBJ$ cleanup is only performed on selected nodes. @   The routine it disables is <Function:kqlclo> (KQL Clean Obj$) which scans @   obj$ for objects marked as non-existent and then deletes them if @   they are not child dependencies of anything.

posted on 2013-03-19 00:32  Oracle和MySQL  阅读(145)  评论(0编辑  收藏  举报

导航