My Oracle Support Banner

Oracle To Teradata Replication Performance Is Very Slow (Doc ID 2510016.1)

Last updated on MAY 11, 2022

Applies to:

Oracle GoldenGate - Version 12.3.0.1.3 to 12.3.0.1.3 [Release 12.3]
Information in this document applies to any platform.

Symptoms

Problem Summary
---------------------------------------------------

Problem Description
---------------------------------------------------
Source :
OS : (Exadata)
RDBMS : 12.1.0.2.0
Goldengate : 12.1.2.1.160705

Target :
OS : AIX 7.1
Teradata Version :
TTU : 16.20
Goldengate : 12.3.0.1.180821

During a test it was seen that 66 Million changes were generated in Source in 10 hours and in the same time period only 6 Million changes were replicated to Teradata on target.

Extracting from <ower>.<table_name> to <ower>.<table_name>: (SOURCE)
*** Daily statistics since 2019-02-11 00:00:00 ***
  Total inserts 82073.00
  Total updates 66454857.00
  Total deletes 13688.00
  Total discards 0.00
  Total operations 66550618.00

Replicating from <ower>.<table_name> to <ower>.<table_name>: (TARGET)
*** Daily statistics since 2019-02-11 00:00:00 ***
  Total inserts 0.00
  Total updates 6172854.00
  Total deletes 0.00
  Total discards 0.00
  Total operations 6172854.00

Cause

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
Symptoms
Cause
Solution


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