Oracle Net "Connect Time" Performance Tuning
(Doc ID 214022.1)
Last updated on MARCH 15, 2021
Oracle Net Services - Version 184.108.40.206.0 to 220.127.116.11 Information in this document applies to any platform.
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.
This article is primarily intended for Application Designers and Database Administrators.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!