Hi ,
This is about Goldengate replication performance.
Have configured Goldengate replication between OLTP and Reporting and the business peak hours occurs only for a one hour.
at that time I can see a LAG on the replicat side of around 10-15 minutes.
Rest of all the time there is no LAG.
I reviewed the AWR report of the target and I could see all the replicat process are executing with a elapsed time of 0.02 or 0.01 seconds.
However I could see a major wait event DB sequential read of 65%-71% of DB time and it is having the maximum Waits. apart from this there are no major wait event contributing to % DB time.(21% od DB CPU which I believe is normal )
and I can also see few queries are being hit at that peak time since it is a reporting server. and they are using select query which executes more than 15-20 minutes specially on the High transaction table.
Can you please advise where I should look on to resolve the LAG during the Peak hours.
I believe the select operation/wait event is causing the LAG during that peak hours. Am I correct.
can you please advise from your experience.
Thanks
Surendran