Login  Register

Golden Gate DDL replication slow

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

Golden Gate DDL replication slow

Roshan
1294 posts
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
| More
Print post
Permalink

Re: Golden Gate DDL replication slow

ErmanArslansOracleBlog
Administrator
5732 posts
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...