From a SQL*Net perspective, the only thing that can be tuned is the SDU size. SDU stands for Session Data Unit. SDU is a buffer at the Network Session (NS) layer from which SQL*Net packets are passed via TDU (Transport Data Unit) at the Network Transport (NT) layer, to the underlying protocol. By default in version 2.3 (7.3), SDU was set to 4K. However, it changes to 2K in Net*8 and Oracle*Net (8.0 and higher)

With the default SDU size of 2K, each block of data was handled as follows:

OCI App ----&gt Net*8 2900 bytes passed
NS ----&gt NT 2048 bytes (2K SDU size is being used)
TCP Layer 1460 bytes - packet 1
588 bytes - packet 2
NS ----&gt NT 852 bytes
TCP Layer 852 bytes - packet 3

If we set SDU to 4K, each block will be handled as follows:

OCI App ----&gt Net*8 2900 bytes passed
NS ----&gt NT 2900 bytes (4K SDU size is being used)
TCP Layer 1460 bytes - packet 1
1450 bytes - packet 2

Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4

調整網路連線引數

可以修改某個網路配置引數後，執行觀察關於網路的等待是否有降低

#TNSNAMES.ORA

ukp9930.world =
(DESCRIPTION =
(SDU=4096) #
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = ukp9930)
(Port = 1521)
)
)
(CONNECT_DATA = (SERVICE_NAME = rep1))
)

#LISTENER.ORA

LISTENER =
(ADDRESS_LIST =
(ADDRESS =(PROTOCOL= TCP)(Host= UKP9930)(Port= 1521))
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SDU=4096)
(SID_NAME = rep1) tnsnames otherwise it will negotiate to
) the lowest of the two sizes
)

[@more@]

調整網路配置SDU

相關文章