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

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 tuning parameters and tools.

Linux TCP tuning

Like most operating systems, the default maximum kernel parameter settings for networking are way too small. For example, the Red Hat Linux kernel version 2.6 has a maximum TCP buffer size of 256 KB for...