Chapter 16: Tuning Network Usage

---

Overview

This chapter will cover Oracle network tuning. Oracle networking software is sometimes known as SQL*Net. Many times I have heard that the only way to tune SQL*Net is to change the SDU or Session Data Unit buffer size. This is not correct. There are many ways in which SQL*Net configuration can be adjusted, improving performance under varying circumstances. The easiest method of describing how, is to describe each facet of SQL*Net tuning, and to display by example. Let's begin with the Listener process and its various possible configurations.

Note 

 Oracle Database 10 Grid   Managing network configuration files is simplified where manual configuration is no longer required. Additionally performance enhancements have been made including support for high-speed networks and better network bandwidth use between database and application servers.

---