Chapter 6. Monitoring, Tuning, and Troubleshooting GoldenGate

In this chapter we will cover the following recipes:

  • Steps to configure a BATCHSQL mode
  • Splitting the replication load into multiple process groups for optimal performance
  • Optimizing the network settings for a GoldenGate configuration
  • Performing a healthcheck of a live GoldenGate configuration
  • Script to perform a regular scheduled healthcheck of a GoldenGate configuration
  • Steps to measure throughput of a GoldenGate configuration
  • Steps to re-instantiate a failed GoldenGate configuration
  • Steps to implement a Heartbeat mechanism for a GoldenGate replication

Introduction

Performance tuning is a key part of any IT implementation. When you install an application with its default options, they sometimes ...

Get Oracle GoldenGate 11g Complete Cookbook 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.

Start your free trial