Two Practical Tips for Oracle’s DBConsole

These 2 tips for Enterprise Manager database control have been tested in 10.2.0.4

Adjusting Collection Interval for Alert Log
 
The default collection interval for scanning alert logs is every 15 minutes which might me too long for some sites.

Here are the steps to adjust the time down to 5 minutes:
 

  1. cd $ORACLE_HOME/<hostname_instancename>/sysman/emd/collection
  2. vi oracle_database_<sid>.xml
  3. Look for “alert_log_rollup”
  4. Adjust “ScheduleInterval=5”
  5. Restart your DB Control.
  6. If RAC, then do the same on rest of the nodes.


Adjusting Logout Time  Interval

If your session remains idle for more than 45 minutes, then DB Control will log you out

Here are the steps to increase the logout time:

  1. cd $ORACLE_HOME/<hostname_instancename>/sysman/config/emoms.properties
  2. vi emoms.properties
  3. add this line to bottom: oracle.sysman.eml.maxInactiveTime=<time in minutes> #1440 for 24 hours
  4. Restart your DB Control.


Hazem Ameen
Senior Oracle DBA

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s