Oracle High Performance Tuning for 9i and 10g
This text covers the three parts of tuning an Oracle database: data modeling, SQL code tuning, and physical database configuration, and explains both problem detection and resolution.
TABLE OF CONTENTS Oracle High Performance Tuning for 9i and 10g
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. |
16.1 The Listener
The Listener is a process residing on a database server or other machine that "listens" for database connection requests. When a request is received the Listener hands off or passes on the connection to a database server process. Following is a very simple Listener configuration file. This file is called listener.ora by default and is placed in the $ORACLE_HOME/network/admin directory.
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST =<i class="emphasis"></i>) (PORT = 1521)) ) ) SID_LIST_LISTENER = ...
Copyright Elsevier Inc. 2004 under license agreement with Books24x7
