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.

Comments

  1. $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]

Comment

*

沪ICP备14014813号-2

沪公网安备 31010802001379号