BEST PRACT ICES FOR SYNCHRONOUS REDO T RANSPORT
Table of Contents
Introduction 1
Data Guard Synchronous Transport – an Overview 2
Synchronous Transport Performance 3
Synchronous Transport Enhancements 4
Oracle Database 11g Release 2 4
Oracle Database 12c 5
Configuration Best Practices 5
Set tcp socket buffer size to 3 x BDP 5
Configure standby redo logs 7
Set SDU size to 65535 7
Configure sufficient resources for optimal system performance 8
Use Fast Sync - SYNC NOAFFIRM 8
Consider Exadata for enhanced performance in a zero data loss conf igur ation 8
TUNING 8
Understanding how synchronous transport insures data integrity 12
Assessing performance 13
How to assess SYNC perform ance with Oracle Database 11.2 16
How to assess SYNC perform ance with Oracle Database 12c 17
Diagnosing High Log File SYNC Waits 18
Data Guard Fast Sync 20
Conclusion 21
评论