To meet a business requirement for latency, Carlos wants to break long-running source
transactions into shorter commits on the target database with the replicate parameter
MAXTRANSOPS what is the most important thing Carlos should consider before using
MAXTRANSOPS
A.
Will business logic be lost if transaction boundaries are changed?
B.
Will a large number of small commits perform better than a smaller number of large
commits?
C.
Will redo buffer size on the target database be adequate for the commit size?
D.
Will the sequence of operations be affected by changing transaction boundaries?
Explanation:
In reference guide, page 238: “Limitations of useYou should have a valid business case for using
MAXTRANSOPS other than simply for thepurpose of expediency. To use MAXTRANSOPS is to
alter the transactional integrity that isimposed by the boundaries that are defined by the source
application, even though Replicatapplies the operations in the correct order.”
A