Is this a hub-n-spoke architecture?
Are the processes integrated?
Does this system do the same thing as the system you are comparing to?
Are there any data types that could be causing issues?
These are just some of the basic questions. A bit more information is needed
before a comparison can be made.
Thanks
Bobby Curtis
http://about.me/dbasolved
Sent from my iPhone
On Dec 17, 2017, at 09:52, Ravi Teja Bellamkonda--
<raviteja.bellamkonda7@xxxxxxxxx> wrote:
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.png>
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.png>
A piece of trail file:
<image.png>
Please let me know what would be next phase of troubleshooting. Any help is
very appreciated.
Thanks & Regards,
Ravi Teja.