Kbase P27174: How to improve the performance of the Oracle DataServer rem
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/09/2003 |
|
Status: Unverified
GOAL:
How to improve the performance of the Oracle DataServer remote clients.
FACT(s) (Environment):
Oracle DataServer
FIX:
The Buffer Message size can be modified to get higher performance in data transmission between the _orasrv and the Progress clients.
This value can be modified with the -Mm startup parameter. The default value is 1024 bytes and the maximum is 32,600 bytes. Try different values for -Mm.
The parameter must be set in the Oracle DataServer broker as well as in the client side.
____________________________________________________________
In the Oracle DataServer broker set the following parameters
_probrkr -S <Service Name> -N TCP -H <Host Name> -Mm <Buffer message size>
Example:
_probrkr -S mybroker -N TCP -H myhost -Mm 8192
In the client side
prowin32.exe <Schema holder name> -1 -db <Oracle instance name> -dt ORACLE -S <Service Name> -H <Host Name> -Mm <Buffer message size>
Example:
prowin32.exe myholder -1 -db sales -dt ORACLE -S mybroker -H myhost -Mm 8192