Avoiding Log-read Bottlenecks in Classic Capture

When Oracle GoldenGate captures data from the redo logs, I/O bottlenecks can occur because Extract is reading the same files that are being written by the database logging mechanism.

Performance degradation increases with the number of Extract processes that read the same logs. You can:

• Try using faster drives and a faster controller. Both Extract and the database logging mechanism will be faster on a faster I/O system.

• Store the logs on RAID 0+1. Avoid RAID 5, which performs checksums on every block written and is not a good choice for high levels of continuous I/O.