3151:Optimizing Oracle Connections with Windows 95
KEYWORDS: Oracle,TCP/IP,optimizing,SQL,Windows 95 AREA: General
Intended Audience:
------------------
Anyone who wants to Improve Oracle IP Connection time under Windows 95.
Prerequisites:
--------------
- Windows 95
- Oracle Client Software Installed & Setup to connect to a Oracle Server
via TCP/IP.
- (Optional) Delphi 2.0 C/S Software to test result.
Purpose of the TI:
------------------
To help speed up Connection time to Oracle under Windows 95. Under WinNT
this is not an issue, therefore, this TI applies only to Windows 95.
Performance times, as seen on some computer's, with &
without this modification are:
Before : Win95 = 10-15 Seconds.
WinNT = 2-3 Seconds.
After : Win95 = 3-4 Seconds. (Big Improvement)
Problem: Windows 95 inherently searches for IPC addresses on some network
nodes PRIOR to making a connection to a Oracle DNS whereas WinNT does not.
Solution: Modify the Oracle SQLNET.ORA file to disable said Windows 95
feature.
Step-by-Step Solution:
----------------------
1) Open SQLNET.ORA via Notepad or Write.
(This file can be found in the <ORA_HOME>\network\admin directory.
Disregard any other occurrences of this file)
This files looks like this:
################
# Filename......: sqlnet.ora
# Node..........: local.world
# Date..........: 24-MAY-94 13:23:20
################
TRACE_LEVEL_CLIENT = OFF
sqlnet.expire_time = 15
names.default_domain = borland.world
name.default_zone = borland.world
2) Add the following Parameter to the SQLNET.ORA file:
AUTOMATIC_IPC = OFF
Modified, the SQLNET.ORA file looks like this:
################
# Filename......: sqlnet.ora
# Node..........: local.world
# Date..........: 24-MAY-94 13:23:20
################
AUTOMATIC_IPC = OFF
TRACE_LEVEL_CLIENT = OFF
sqlnet.expire_time = 15
names.default_domain = borland.world
name.default_zone = borland.world
3) Save the file the new SQLNET.ORA file and voila! Anytime an Oracle
Connection is initiated, performance with increase from 15 seconds to
3 seconds required. This improves Delphi's already blazing speed.
TI
LiveJournal
PhotoFile