Assessing and Tuning Network Performance for Data Guard and RMAN
(Doc ID 2064368.1)
Last updated on NOVEMBER 16, 2020
Applies to:
Oracle Cloud Infrastructure - Database Service - Version N/A and laterOracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Goal
The goal of this note is to provide steps to evaluate network bandwidth and experiments that will help tune operating system, Oracle Net or RMAN parallelism (only relevant for RMAN operations)
- Scenario 1- Understand the existing network and evaluate tuning options prior to database migration, Data Guard deployment or RMAN operations for a large database.
It is critical that you have sufficient network bandwidth to support peak redo rates (steady state and when resolving gaps) along with any other network activity that shares the same network. Please note that your point-to-point network bandwidth will be throttled by the network segment, switch, router, and interface with the lowest network bandwidth. Using oratcptest as described below can help you determine if enough bandwidth is available given other resources using the shared network.
- Scenario 2- Post deployment: experiencing a transport lag with the ASYNC transport
With enough network bandwidth, ASYNC transport can maintain pace with very high workloads, up to approximately 400MB/sec per instance. In cases where resources are constrained, the ASYNC transport can fall behind, resulting in a growing transport lag on the standby. A transport lag is the amount of data, measured in time that the standby has not received from the primary. Determine transport lag on the standby database by querying the V$DATAGUARD_STATS view using a query like the following:
Solution
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
Goal Solution Installation and Usage of oratcptest Determining Optimal Socket Buffer Size Socket buffer size Determine Optimal Socket Buffer Size Configuring Operating System Maximum Buffer Size Limits Scenario 1 - Understand the existing network and evaluate tuning options prior to database migration, Data Guard deployment or RMAN operations for a large database Determine existing bandwidth between source and target using parallelism Determine Bandwidth for a Single Node Determine Concurrent Bandwidth of a Cluster Scenario 2- Post Data Guard deployment: experiencing a transport lag with ASYNC transport Configuring Redo Transport for Optimal Network Performance Determine Required Network Bandwidth Assessing Network Performance for Data Guard Asynchronous (ASYNC) Redo Transport Determine Available Network Bandwidth for ASYNC Transport Configuring Socket Buffer Sizes Used by Data Guard Asynchronous Redo Transport Scenario 3: Determine Maximum Network Bandwidth or Evaluate Potential RMAN Operation Throughput Scenario 4- Post deployment: tuning transaction response time rates with SYNC transport Assessing Network Performance for Data Guard Synchronous Redo Transport Setting Oracle Net SDU for SYNC Transport Setting SDU for Oracle RAC Setting SDU for Non-Oracle RAC Use oratcptest to Assess SYNC Transport Performance Determine Redo Write Size Run tests with oratcptest Implement FASTSYNC Increase Socket Buffer Size References My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.