For OLTP applications only, the use of shared servers to support more clients with fewer
processes.
The buffer size used by Oracle Net should take advantage of the packet sizes used by the
network protocols (such as TCP/IP). If you send large packets of data across the network, the
packets may be fragmented. Because each packet contains header information, reducing packet
fragmentation reduces network traffic.
You can tune the size of the service layer buffer. The specification for the service layer data
buffer is called SDU (Session Data Unit); if it is changed, this must be specified in your client and
server configuration files. Oracle Net builds data into buffers the size of the SDU, so altering that
size may improve your performance. The default size for the SDU is 8KB in Oracle Database 11g,
and 2KB in earlier versions. If you will frequently be sending messages that are much larger than
that, you can increase the SDU (up to a maximum of 32KB).
To configure the client to use a nondefault SDU, add the new SDU setting to the client
configuration files. For the change to apply to all connections, add the following parameter
to the sqlnet.ora file:
DEFAULT_SDU_SIZE=32767
For the change to apply to only specific service names, modify their entries in the tnsnames.
ora file:
LOC =(DESCRIPTION=
(SDU=32767)
(ADDRESS=
(PROTOCOL=TCP)
(HOST=HQ)
(PORT=1521))
(CONNECT DATA=
(SERVICE_NAME=LOC)))
On the database server, configure the default SDU setting in the sqlnet.
Pages:
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809