Hi,
Hope this helps you.
Regards,
Rajanish Joshi
Pune,India
starts from this -----------------------******---------------------
#*****************************************************
#File Name: sqlnet.txt##Purpose: How to set the SQL*Net Packet Size.
##*****************************************************
SQL*Net 2.3 allows you set the packet sizes via the
two parameters 'SDU' and 'TDU'. These specify the sizes of the
'Service' and 'Transport' layer buffers, respectively.
Prior to Oracle 7.3, SDU and TDU are fixed at 2k.
In Oracle 7.3 and above, these are tunable above 2k.
The SDU parameter size is tunable (up to 32K) as of Oracle 7.3.
For example, in the TNSNAMES.ORA you can set the parameters SDU and TDU:
sales= (DESCRIPTION= (SDU=8192) <<**** service layer buffer size
(TDU=8192) <<**** transport layer size
(ADDRESS= (PROTOCOL=tcp) (PORT=1521) (HOST=myhost))
(CONNECT_DATA= (SID=prods)) ) It is possible to set TDU different than SDU,
however, there is no advantage to doing so. For instance, if TDU=1k and SDU=1536, then 512 and
then 1024 bytes of data will be sent to the transport.If TDU=2k and SDU=1536, then 1536 bytes of
data is sent to the transport.LISTENER.ORA: The parameters need to appear in the SID_DESC
clause.
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SDU = 8192)
****** Connects to this SID (TDU = 8192) ****** using and 8k packet size.
(SID_NAME = prods) (ORACLE_HOME = /myhost/unix/oracle7) ) (SID_DESC =
****** This defaults to (SID_NAME = prods) ****** generally 2K.
(ORACLE_HOME = /myhost.unix/oracle7)) ) INIT(SID).ORA: If you are using MTS,
you cannot set TDU/SDU sizes until Oracle 7.3.3.
For example, in Oracle 7.3.3,
MTS_DISPATCHERS="(DESCRIPTION=(SDU=8192)\ (TDU=8192) (ADDRESS=(PARTIAL=TRUE)\
----------------------end of file --------------------------------------
__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
Received on Wed Nov 22 2000 - 00:26:33 CST
