Speed up SQL*NET V2.1

From: Megan Bromley <megan_at_cm.co.za>
Date: 1995/07/19
Message-ID: <3uj5c5$2q0_at_baloo.cm.co.za>#1/1


We have recently installed SQL*Net V 2.1.4.1.0 on our test system. The application developers complain that it is much slower that SQL*Net V 1. Typically, in a day, the number of servers started and terminated is approximately 600. The servers highwater is 19. In the init file I have specified the following parameters:

MTS_SERVERS=5
MTS_MAX_SERVERS=40
MTS_DISPATCHERS="tcp,4"
MTS_DISPATCHERS="ipc,1"
MTS_MAX_DISPATCHERS=15

Our Oracle version is 7.1.4 and OS version is HP-UX 9.01 on an HP Series 700.

Does anyone have ideas about how to improve the performance of SQL*Net2? I would appreciate any help.

Thanks.
Megan

(e-mail megan_at_cm.co.za) Received on Wed Jul 19 1995 - 00:00:00 CEST

Original text of this message