Tuning the network
Another key area to focus on is the network. A poorly performing network will cause high latencies and possible disconnections. One easy method to determine whether your GoldenGate implementation is suffering from network delays is to check whether your Extract process write checkpoints are increasing at the same rate. For example, if your primary Extract process is check-pointing frequently as compared to the data pump process, it indicates that the data pump process cannot write to the remote trail quickly enough. So, what can be done about it?
We can look at increasing the data throughput by adjusting OS TCP socket buffers, TCP packet sizes, transmission queue lengths, and so on. Let's take a look at some of the common network ...
Get Oracle GoldenGate 12c Implementer's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
