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.
$cat _smon_32440.trc|grep -B2 namespace=TABL
name=SYS.SMON_SCN_TIME
hash=64364cd39e83bca37e6006b5672109bb timestamp=03-12-2008 00:40:22
namespace=TABL flags=KGHP/TIM/SML/[02000000]
—
name=SYS.MON_MODS$
hash=df1bb295b5059c6267f1ab1c62b948c4 timestamp=03-12-2008 00:40:00
namespace=TABL flags=KGHP/TIM/SML/[02000000]
—
name=SYS.COL_USAGE$
hash=424f2fc316c1e986ebd61129d2da1b83 timestamp=03-12-2008 00:40:21
namespace=TABL flags=KGHP/TIM/SML/[02000000]
—
name=SYS.FET$
hash=ebbd04e5693db8814ccf17a96c13497e timestamp=03-12-2008 00:39:48
namespace=TABL flags=PKP/KGHP/TIM/KEP/SML/BSO/[02900002]
—
name=SYS.TS$
hash=470fcbc62b4c96ac89843f456219060e timestamp=03-12-2008 00:39:48
namespace=TABL flags=PKP/KGHP/TIM/KEP/SML/BSO/[02900002]
—
name=SYS.TAB$
hash=dba1f47a6c1943c58ece900e1400a489 timestamp=03-12-2008 00:39:48
namespace=TABL flags=PKP/KGHP/TIM/KEP/SML/BSO/[02900002]
—
name=SYS.USER$
hash=bcbc05875d5d31ba1d668ecc7b18ab07 timestamp=03-12-2008 00:39:48
namespace=TABL flags=PKP/KGHP/TIM/KEP/SML/BSO/[02900002]