Technical Information Database TI1397D.txt - Optimizing Oracle Connections with Windows 95 Category :Database Programming Platform :All-32Bit Product : Description: 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\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. Reference: 4/22/99 1:05:44 PM
Last Modified: 01-SEP-99