My Oracle Support Banner

GoldenGate Performance Tuning, Configuration Attributes & Monitoring (Doc ID 1455566.1)

Last updated on DECEMBER 14, 2022

Applies to:

Oracle GoldenGate - Version 10.4.0.0 and later
Information in this document applies to any platform.

Purpose

 The purpose of this document is to discuss the following areas

1. How to monitor GoldenGate performance through the use of Oracle GoldenGate GGSCI commands and GoldenGate Process Parameters.

2. GoldenGate Process Parameters relevant to improving GoldenGate throughput.

3. Design techniques to improve GoldenGate throughput.

 

Scope

 This document is relevant to GoldenGate administrators.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Monitoring GoldenGate Performance
 Oracle GoldenGate GGSCI Commands
 Oracle GoldenGate Parameters
 Monitoring Latency using a Heartbeat Table
 GoldenGate Process Parameters relevant to improving throughput
 Improving Extract performance
  Improving Datapump performance
 Eliminating Network bottlenecks
 Reducing Network Packets sent and received
 Reduce bandwidth requirements
 Oracle GoldenGate Parameters - Replicat
 Using BATCHSQL
 Design Techniques to improve GoldenGate throughput
 Memory Consumption
 CPU consumption
 Eliminating I/0 bottlenecks
 Gain network bandwidth
 Using Parallel Replicats
 General Performance Improvement techniques
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.