Again, i'm used to DBA'ing SQL Server, where setting the network packet size that the server uses to send data to the clients is done in a simple command. Now, I know where you can set the SDU and TDU in the TNSNAMES, but its my understanding that this is a client based setting, instead of a server based setting.
Unfortunatly, the Oracle Metalink didnt provide much help either. Does anyone know of a way to set the network packet size on the Oracle server, if its possible?
From meta link
ukp9930.world = (DESCRIPTION =
(SDU=4096) #<-- SDU can be set from 512 bytes to 32Kb
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = ukp9930)
(Port = 1521)
(CONNECT_DATA = (SERVICE_NAME = rep1) ) )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
(SDU=4096) <---------- SDU has to match the setting in
(SID_NAME = rep1) tnsnames otherwise it will negotiate to
) the lowest of the two sizes