Network latency / performance issue tuning for Solaris 10 -> Solaris 11.3.7.5.0

(Doc ID 2072384.1)

Last updated on MAY 18, 2018

Applies to:

Solaris Operating System - Version 10 3/05 to 11.3 [Release 10.0 to 11.0]
Information in this document applies to any platform.

Symptoms

This doc descibes a specific example of a more general performance / latency issue, which may affect any workload.

Here we have an Oracle Databases moving data between three different DB instances with the Oracle "DB link" feature.  This data transfer reported high levels of latency - of 70-100 milliseconds vs. the expected 5-10 milliseconds, and of course much reduced throughput as a result.

This impacted overall database performance and resulted in end-user complaints about response times. 

Changes

Nothing really changed, although it is likely the overall database workload had increased somewhat,  with the overall impact enough to trigger user complaints.  

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms