Performance tuning is one of the main aspects of any IT project. Many project managers leave it to the end and then realize that it is not possible to make the necessary changes without investing additional resources and time. Performance must be considered at the beginning, the design phase, and throughout the lifetime of the project. Closely connected to the design aspect, this chapter explores performance tuning tips and best practices.

Oracle states that GoldenGate can achieve near real-time data replication. However, out-of-the-box, GoldenGate may not meet all of your performance requirements. Here, we will focus on the main areas that lend themselves to tuning, especially parallel processing and load balancing, enabling high data throughput and very low latency.

In this chapter, you will learn the following topics: