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...