Controlling the memory consumption

Oracle GoldenGate 12c supports up to 5,000 concurrent Extract and Replicat processes per instance. The actual amount of physical memory that is used by a process is controlled by the operating system up to its soft limit within the global system cache, not the GoldenGate program. However, the GoldenGate cache manager can be configured to reduce the process memory consumption if required.

The CACHEMGR parameter of the Extract or Replicat controls the amount of virtual memory and temporary disk space that is available to cache uncommitted transactions that are being processed by GoldenGate. As the cache manager adjusts itself internally, most production environments do not require changes to this parameter. However, if performance issues are evident, look at the statistics generated by the SEND EXTRACT or SEND REPLICAT GGSCI commands when used with the CACHEMGR CACHESTATS option. The statistics show the size of the memory pool, the paging frequency, the size...