Golden Gate Replicat behaving differently in different environment

From: Ravi Teja Bellamkonda <raviteja.bellamkonda7_at_gmail.com>
Date: Sun, 17 Dec 2017 06:52:59 -0800
Message-ID: <CANRhLpDhQiT+dGZXoRXy+N-5Vrfb6+dAHUr=JGJ_9C_w-MwKoA_at_mail.gmail.com>

Hi List,

We have a GG Setup where extract and replicat processes are running remotely.

GG Version: 11.2.1.0.3

Database: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

The Replicat is slow in terms of no of transactions it is processing and lag is falling behind.

[image: Inline image 1]

Generated AWR for target database and there is very little activity and the no of sql executions are very low when compared with other replicat in a different environment. The rate at which the replicat is reading the trail file is very slow.

[image: Inline image 2]

A piece of trail file:

[image: Inline image 3]

Please let me know what would be next phase of troubleshooting. Any help is very appreciated.

Thanks & Regards,
Ravi Teja.

--
http://www.freelists.org/webpage/oracle-l




image/png attachment: image.png



image/png attachment: image.png



image/png attachment: image.png

Received on Sun Dec 17 2017 - 15:52:59 CET

This message: [ Message body ]
Next message: Bobby Curtis: "Re: Golden Gate Replicat behaving differently in different environment"
Previous message: Jonathan Lewis: "Re: Comparing apples to apples on Exadata"
Next in thread: Bobby Curtis: "Re: Golden Gate Replicat behaving differently in different environment"
Reply: Bobby Curtis: "Re: Golden Gate Replicat behaving differently in different environment"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message