My Oracle Support Banner

Oracle Net "Connect Time" Performance Tuning (Doc ID 214022.1)

Last updated on MARCH 15, 2021

Applies to:

Oracle Net Services - Version 8.0.1.0.0 to 11.2.0.1
Information in this document applies to any platform.

Purpose

In many application architectures, such as a three-tiered architecture, Clients (such as middle tier or web servers) require quick connect times in order to optimize the whole web sites response time requirements. The process of the Client connecting to the database is well documented in the Oracle Net Administrator's Guide. This document is intended to illustrate the optimal settings for Oracle Net to accomplish quick connect times. Though these suggestions are valid to increase connect times, they may not be valid for a particular architecture, so testing of these suggestions is highly recommended to assure actual performance and availability gains.

The connection process includes several steps. The first part involves the resolution of the connect descriptor. The next steps contributing to the time taken for Client connection include:

1. The time taken for the network protocol to connect the Client host to the Listener host
2. For the Listener to create either a dedicated server process or determine which Dispatcher is to be used
3. The time it takes for the Client process to complete the TNS connect to the Server process.

The timings used in this article are drawn from Oracle Net trace files with time stamping enabled. To eliminate as many variables as possible, the examples used throughout this article consistently denote particular sections of trace files used. That is, from the beginning of the trace file to a specific location within the trace file that denotes the global memory used during the connection process.

Scope

This article is primarily intended for Application Designers and Database Administrators.

Details

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
Purpose
Scope
Details
 ORACLE NET CONNECT TIME PERFORMANCE TUNING
 RESOLVING THE CONNECT DESCRIPTOR
 NAMES.DIRECTORY_PATH
 SHARED SERVER OR DEDICATED
 LISTENER QUEUE SIZE AND MULTIPLE LISTENERS
 CONCLUSION

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