SQL*Net允许dba通过调整两个参数SDU(Session Data Unit)和TDU(Transmission Data Unit )在packet大小上进行网络传输控制。
这些参数会控制会话层和传输层的buffers。
#SDU是会话数据单元..TDU是传输数据单元,是oracle NET用来组织包的大小,
#TDU最好等于SDU.版本7.3之前参数限制为2k.
#客户端和服务器端的示例配置:
#TNSNAMES.ORA: The parameters must appear in the DESCRIPTION clause.
TEST =
(DESCRIPTION =
(SDU=8192) <<**** Calls to this alias will
(TDU=8192) <<**** try to put 8K into packets.
(ADDRESS = (COMMUNITY = TCP.uk.oracle.com)
(PROTOCOL = TCP)
(HOST = test)
(PORT = 1521)
)
(CONNECT_DATA = (SID = test))
)
#LISTENER.ORA: The parameters must appear in the SID_DESC clause.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SDU = 8192) <<**** Connects to this SID will
(TDU = 8192) <<**** try to use put 8K into packets.
(SID_NAME = test)
(ORACLE_HOME = /oracle/product/9.2.0)
)
(SID_DESC = <<**** This one will default
(SID_NAME = test) <<**** (generally to 2K)
(ORACLE_HOME = /oracle/product/9.2.0)
)
)
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/6906/viewspace-21813/ ,如需转载,请注明出处,否则将追究法律责任。