DanBrother的部落格

Oracle Enterprise Manager 11g Grid Control Maintenance Tips:

In the 11g Grid Control version, the OMS configuration files:emoms.properties and emomslogging.properties are no longer used. Instead, the OMS/Repository configuration and logging properties are now stored in the Repository Database itself.

 Stop the OMS by:

$OMS_HOME/bin/emctl stop oms -all

1. Set a new thread Pool Size by:

# cd $OMS_HOME/bin
# ./emctl set property -name em.loader.threadPoolSize -value 2
Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
SYSMAN password:
Property em.loader.threadPoolSize for oms Oracle11g-gc:4889_Management_Service has been set to value 2

 Start the OMS by:

$OMS_HOME/bin/emctl start oms

2. Check the new em.loader.threadPoolSize value by :
# ./emctl get property -name em.loader.threadPoolSize

or
# ./emctl list properties


3. Exporting Config File By:
#./emctl exportconfig oms

4. Make a copy of the emkey.ora file located in $OMS_HOME/sysman/config/

5.  Run SQL Advisors (SQL Access Advisor & SQL Tuning Advisor) on GC repository DB over time to review recommendations for creating indexes  and SQL profiles.
The reason is that GC repository DB is not tuned for optimal performance by default.