Book Image

Oracle Goldengate 12c Implementers Guide

By : John P Jeffries
Book Image

Oracle Goldengate 12c Implementers Guide

By: John P Jeffries

Overview of this book

The book is aimed at Oracle database administrators, project managers, and solution architects who wish to extend their knowledge of GoldenGate. The reader is assumed to be familiar with Oracle databases. No knowledge of GoldenGate is required.
Table of Contents (16 chapters)
12
A. GGSCI Commands
13
B. GoldenGate Installed Components
14
C. Acronyms
15
Index

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