Oracle
1Z0-539 · Question #55
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…
The correct answer is B. Will a large number of small commits perform better than a smaller number of large commits? See the full explanation below for the reasoning.
Question
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
Options
- AWill business logic be lost if transaction boundaries are changed?
- BWill a large number of small commits perform better than a smaller number of large commits?
- CWill redo buffer size on the target database be adequate for the commit size?
- DWill the sequence of operations be affected by changing transaction boundaries?
How the community answered
(29 responses)- A3% (1)
- B83% (24)
- C10% (3)
- D3% (1)
Community Discussion
No community discussion yet for this question.