Technical Note: Understanding Performance in Oracle Active Data Guard Far Sync (Part Two)

Axxana’s research team recently conducted a series of tests on fine-tuning Oracle Active Data Guard Far Sync for optimal performance within the Phoenix for Oracle Far Sync environment. This Technical Note focuses on how to leverage I/O caching to relieve pressure from the I/O subsystem, and how to smooth the impact of archiving. We show that careful configuration of these parameters can lead to significantly less I/O (eliminating all reads) and a much smoother I/O pattern in multi-instance environments. Findings are also relevant to customers tuning Far Sync in virtualized and non-virtualized environments.

* These fields are required.