Oracle To Teradata Replication Performance Is Very Slow
(Doc ID 2510016.1)
Last updated on APRIL 17, 2023
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 |