Re: Golden Gate Replicat behaving differently in different environment

The AWR will just show you what SQL is being ran against the database. If you were using integrated products (extract/replication), then the AWR may be of some help; in this case not so much.

I would start looking at your checkpoints for the extract and replicat (info extract <name>, show how). Then make sure data is being written to the trail file and that the replicat is not at the end of a file.

Using classic processes (extract/replicat), you need to troubleshoot from the OS side. These processes rely heavily on the OS memory as well.

Bobby Curtis
Sent from my iPad Pro

> On Dec 17, 2017, at 10:38 AM, Ravi Teja Bellamkonda <raviteja.bellamkonda7_at_gmail.com> wrote:
>
> Is this a hub-n-spoke architecture?
>
> Yes, this is a hub-n-spoke architecture.
>
> Database A -> GG Server -> Database B.
>
>
> Are the processes integrated?
>
> No these are not integrated processes.
>
> Does this system do the same thing as the system you are comparing to?
>
> Yes, Both the systems are supporting same applications.
>
> Are there any data types that could be causing issues?
>
> We have lot of DML Operations on a table with CLOBs. But it is still the same on both environments.
>
> Snippet of Target AWR for environment in which replicat is slow,
>
> <image.png>
>
> The first 3 SQL are Insert, Delete and Update respectively.
>
>
> The following is the snippet where Replicat is processing faster comparatively.
>
> <image.png>
>
> This is odd that no of executions are high in this target which is a bit confusing for me. Please let me know any more info is needed.
>
> Thanks a lot for your time.
>

>> On Dec 17, 2017 7:23 AM, "Bobby Curtis" <curtisbl_at_gmail.com> wrote:
>> 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_at_gmail.com> 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.

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