Chapter 9. Performance Tuning

Performance tuning is one of the main aspects of any IT project. Many leave it to the end and then realize that it is not possible to make the necessary changes without significant additional investment or time constraints. Performance must be considered at the beginning and throughout the lifetime of your project. Closely coupled to the design, this chapter hones in on individual performance tuning methods.

Oracle states that GoldenGate can achieve near real-time data replication. However, out of the box, GoldenGate may not meet your performance requirements. Here we 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, we learn the following:

• Balancing load across multiple processes

• Splitting large or transaction intensive tables across parallel process groups

• Adding additional Replicats to a process group

• Improving Replicat throughput by reducing...