My Oracle Support Banner

Oracle Net Performance Tuning (Doc ID 67983.1)

Last updated on MARCH 19, 2024

Applies to:

Oracle Net Services - Version and later
Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


To assist with SQL*Net / Net8 / Oracle*Net Performance Tuning.

Note: This document contains references to obsolete parameters. These parameters do not affect the purpose of this document in any way, which is to understand performance tuning with SQL*Net / Net8 / Oracle*Net (all of which will now be referred to SQL*Net in this note unless specific to a particular version).


This note in intended to assist Oracle Engineers and Oracle Customers with analysis and possible tuning of performance at the Oracle Net level. Much of the data is based on basic skills but some needs to be attended to only by experienced related persons. When these changes need specific skills, it is mentioned.

Please remember that any changes to Oracle or TCP parameters may affect other functions so please make changes with this in mind.


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
 Setting the ARRAY Fetch Size in the Application
 Setting the SDU size
 Miscellaneous Items
 Tuning Network

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.