Re: Help with changing buffer size in SQL*NET 2.0

phil_at_prague.demon.co.uk (Phil Jennings) writes:

>Kevin Sacristan <ksacrist_at_tcam.stratus.com> wrote:
 

>>Hello. Hopefully someone here can give me a hand. I am using SQL*NET for
>>Windows 2.0 and I need to change the buffer size (transfer block size) on
>>the messages from the client to the server (and visa-versa).
 

>I don't think that it's possible to change the buffer size with
>SQL*Net V2 - I think it's hard-coded at 2048.

It was not documented in the SQLNET manual, but Oracle support gave me the following syntax which I tested between a SS1000/E and a Banyan Vines network:

	# tnsnames.ora
	test716 =
		(DESCRIPTION =
		  (ADDRESS =
		  (PROTOCOL = tcp)
		  (PORT = 1526)
		  (HOST = locws140049.shl.com)
		)
		(CONNECT_DATA =
			(SID = test716)
		)
		# Set buffer size to 1024
		(SDU=1024)
	)

-- 
Neil Greene
Senior Oracle DBA / Unix System Administrator
SHL Systemhouse, Inc.  	LA Outsourcing Center 	
<HREF=mailto:ngreene_at_shl.com>
-- 
Neil Greene
Senior Oracle DBA / Unix System Administrator
SHL Systemhouse, Inc.  	LA Outsourcing Center 	
<HREF=mailto:ngreene_at_shl.com>