Moneycontrol Brokerage Recos

Saturday, May 25, 2013

How to increase Oracle 11g OEM heap Size?


When we try to compare or synchronize data between two databases using OEM, OEM should have enough space required to perform well without any glitches. So in order to avoid Heap Size issue or to resolve Heap size issue yon can follow the following set of steps.

Run the following command to increase dbconsole heap size. You can define enough Heap Size value for the parameter -heap_size as per your requirement.

$ emctl config dbconsole -heap_size 512M
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
https://RAC-1:1158/em/console/aboutApplication
OMS heap size properties successfully added to emoms.properties file.


 The changes we made to increase the heap size will take effect after restarting the dbconsole.

$ emctl stop dbconsole

Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
https://RAC-1:1158/em/console/aboutApplication
The OracleDBConsoleorcl service is stopping...........

The OracleDBConsoleorcl service was stopped successfully.

 $ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
https://RAC-1:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ...The OracleDBConsoleor
cl service is starting.....................

The OracleDBConsoleorcl service was started successfully.

 Hope it will help…………!!