Database Reference
In-Depth Information
The parameters should then be added to the connection descriptor on the client system or to the SQL*Net file.
For example, the following SDU settings in the TNS connection descriptor will set the value of the SDU to 16K:
SSKYDB =
(DESCRIPTION =
(SDU = 16384)
(FAILOVER = ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = oradb-scan.sumsky.net)(PORT = 1521))
(LOAD_BALANCE = YES)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SSKYDB)
(FAILOVER_MODE =
(TYPE = SELECT)(METHOD = BASIC)(RETRIES = 10)(DELAY = 3)
)
)
)
Similar settings should also be made to the listener to ensure that the bytes received by the server are also of a
similar size. For example, the following SDU settings to the listener will set the receive value to 16K:
SID_LIST_LISTENER =
(SID_DESC =
(SDU=16384)
(SID_NAME = SSKY1)
))
Network delays in receiving user requests and sending data back to the users affect the overall performance of the
application/environment. This also adds to the transmit time. Such delays translate themselves into SQL*Net related
wait events (wait events are discussed later).
Similar to the MTU settings we tuned for the private interconnect (discussed in Chapter 4), the SDU settings for
the SQL*Net connect descriptor can also be tuned. Optimal SDU settings can be determined by the repeated data/
buffer requests by enabling SQL*Net and listener trace at both the client and server levels.
SQL*Net tracing can be enabled by adding the following parameters to the SQLNET.ora file on the client
machines located in $GRID_HOME/network/admin directory:
trace_level_client=16
trace_file_client=client
trace_timestamp_client=ON
Listener tracing on the servers can be enabled by adding the following parameters to the listener.ora file to trace
connections made to a specific listener or the sqlnet.ora file to trace connections to all listeners. These files are on the
server side in the $GRID_HOME/network/admin directory:
trace_level_server=16
trace_file_server=server
trace_timestamp_server=ON
Trace files are generated in $GRID_HOME/network/trace directories on the respective servers.
Search WWH ::
Custom Search