Re: Help ? Urgent SQL*NET question...

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Sat, 21 Apr 2001 04:59:57 GMT
Message-ID: <3ae1118c.1085379@news-server>

On Fri, 20 Apr 2001 19:21:48 +0100, "Dorian Creber" <dorian_at_ntlworld.nospam.com> wrote:

>I'm trying to find out how to set the "default array size" in sql*net
>v2.x.... ???
>

Dorian, "default array size" got nothing to do with sql*net, AFAIK. It's an application (client-side) specific. It has to be set at client program level. EG: in SQL*Plus client, you "set array 100". In PRO*C, it has to do with how you define your host variables and how they are passed to ORACLE. I suppose the Java side will have a similar setting somewhere, although I wouldn't have a clue where.

As Sy said, there is a thing called SDU which you can set in sql*net, but that is kinda like a "block size" for Oracle net communications. Recommend you set it at a multiple of 1500, which is the default TCP/IP "block size". The Net8 manual explains how to set it at listener and client levels. It's done respectively in the listener.ora and tnsnames.ora (or Onames register command).

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Fri Apr 20 2001 - 23:59:57 CDT