Golden Gate DDL replication slow

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Golden Gate DDL replication slow

Roshan
Source: RHEL 7.4 + Oracle DB 12.1.0.2
Target: Windows Server 2019 + MSSQL DB

Hi,

I noticed replication of a table with 3.2 million records is taking lots of time. It usually takes 6 hours to complete.

I checked the WIndows server COU and RAM are ok. Do you think the problem is with the Network card?
The Windows server is running very slow.

CU.JPG
Network1.JPG
RAM.JPG

Kindly advise
Reply | Threaded
Open this post in threaded view
|

Re: Golden Gate DDL replication slow

ErmanArslansOracleBlog
Administrator
This type of a lag can introduced while reading the redo, transffering it through network or writing the data. writing to a trail or writing to the database.. A performance problem inside the database can also trigger this kind of a lag.
However; it seems you already pointed out a pressure on the network.. Seems like it reaches its limits.. So, why not start diagnosing from there...