Oracle GoldenGate Performance Data Gathering (Doc ID 1488668.1)

Last updated on MARCH 23, 2022

Applies to:

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

Purpose

This note describes the relevant and required pieces of data that should be gathered to carry out a comprehensive performance analysis of Oracle GoldenGate running against a source or target Oracle Database.

Refer to the MAA GoldenGate Performance Best Practices Technical Brief for recommendations and complete performance tuning methodology: http://www.oracle.com/technetwork/database/availability/maa-gg-performance-1969630.pdf

Troubleshooting Steps

	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

Troubleshooting Steps

1. Automatic Workload Repository (AWR) reports (Extract and Replicat)

2. Active Session History (ASH) reports (Extract and Replicat)

3. CPU data (Extract and Replicat)

4. I/O data (Extract and Replicat)

5. GoldenGate Error log (Extract and Replicat)

6. GoldenGate Report file (Extract, Replicat and Manager)

7. Database Alert.log (Extract running in Integrated Capture mode and all types of Replicat)

8. Integrated Capture Healthcheck (ICHC) (Extract running in Integrated Capture mode and Integrated Replicat)

9. Streams Performance Advisor (SPADV) (Extract running in Integrated Capture mode and Integrated Replicat)

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