Optimizing the network settings for a GoldenGate configuration
You can use GoldenGate to replicate data between two schemas within the same database; however, in most cases you will use GoldenGate to replicate the data between two databases that are running on different systems. These systems can be quite far from each other in different locations. One of the key functions performed by the GoldenGate processes is transferring the files to the remote destination. Even though you have the best tuned database with a well-tuned GoldenGate Replicat process, it will not apply any changes if they are not transferred to the target system by the Extract/Datapump process. In order to transfer the data efficiently and make the best use of the network, there are certain things that you need to consider and tune at the GoldenGate and operating system level. In this recipe, we will look at the configuration required to ensure an efficient transfer of GoldenGate trail files between two systems.