GoldenGate

Hi All,

I have a big doubt if anyone can give clarity. The scenario is :- In my environment data is flowing from Oracle to Oracle but Huge transactions in Millions and we use this tool basically to improve LAG when we get data for reporting.

Now let's say I have database user A which is doing some temporary transaction on source for couple of hours but it is HUGE and generating lot of archives AND we don't want to flow any data from the transaction being performed by user A - so we use EXCLUDEUSER A parameter.

Now during same time if any other user say B is performing some operation in one table - we want it to flow, So it is flowing normally BUT the main problem is LAG increased like anything cause GoldenGate is now reading all the redo or archives which of no use and data is flowing very slowly :( :(

My point was will it be also possible that I don't want my GoldenGate to read any redo log or archives if the user A is performing operation and read only those archives if user B or any other user is performing some operation. This will improve the LAG cause even though we ignore the particular user, It is still going to read all the redo or huge archives generated by user A or user B or whatever in sequence, Please correct me if I am wrong ?

I suppose goldengate is going to read all the transaction regardless of A or B user. Only it will ignore the A and process transaction of B.


I know it reads in sequence but can't it read specific archives which is useful instead of reading all.