Oracle High Performance Tuning for 9i and 10g
|
| < Day Day Up > |
|
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. |
|
| < Day Day Up > |
|