Reducing Memory Usage

Follow
Description

There are a few things you can do that will help if you are extremely low on resources and reduce the memory usage. This is applicable for Version 7.0

Solution

  1. Make sure you are using the latest Dbvisit standby. There is a major performance improvement using version 7.0.10 and later. It is recommended to use the latest version available (7.0.14 at time of writing).
  2. Do not use the Dbvisit GUI or the GUI scheduler. You can run Dbvisit via the Unix Cron schedule. You can then shutdown the GUI (dbvserverd) saving that memory/cpu.
  3. If you are using version 7 of Standby, you can possibly disable Dbvnet and just use SSH. Set the DBVNET port to null / empty value. Make sure an SSH port is set in the DDC file. Also the oracle Unix account must be able to SSH between the primary/standby servers without passwords.
  4. Set COMPARE_CHECKSUM = N in the primary DDC files. The change will be applied to standby DDC on next run.
  5. Set RUN_INSPECT=N in the primary DDC files. The change will be applied to standby DDC on next run. But please note if you do this the internal repository will not have historical information for reporting. If you do not use this feature, then setting this value will help.
  6. You can possibly run Dbvisit on only one of the nodes, but then you must use the RAC_TAKEOVER_FORCE=Y option in the DDC.

 

We suggest to try out first five options , Few more tuning options have been provided in the below link.

https://dbvisit.atlassian.net/wiki/display/UGDS7/Performance+Tuning+Options

Donna Zehl May 14, 2014 02:26

Have more questions? Submit a request

Comments