RedoApplyBestPractices.PDF

Redo Apply Best Practices Oracle Data Guard and Active Data Guard ORACLE WHITE PAPER | OCTOBER 2015 Table of Contents Introduction 1 Redo Apply Best Practices 1 Size Online Redo Logs / Standby Redo Logs Appropriately 1 Proper Standby Redo Log Placement and Creation 2 Use Standby Statspack 2 Set DB_CACHE_SIZE to a Value Greater than on the Primary Database 2 Set DB_BLOCK_CHECKSUM and DB_BLOCK_CHECKING 2 Review Database Wait Events 3 Tune I/O Operations 3 Review System Resources 3 Redo Apply Performance 3 Redo Transport 5 Redo Apply Rate 5 Database Wait Events 6 System Resources 8 Monitoring CPU 8 Monitoring Memory Usage 8 Monitoring I/O 9 PERFORMANCE TUNING EXAMPLE 9 CONCLUSION 10 Appendix A