Filter
Top Products
10-42
Surveyor
User’s Guide
TNS Slow Server Response
Counter
TNS Slow Server Response is a counter of TNS server responses that exceed a
threshold. A count of all TNS Slow Server Responses displays in the
Overview
counters of Expert View.
Expert Symptom
TNS Slow Server Response events are automatically logged as expert symptoms.
The
Symptom Summary field provides information about the time elapsed for the
server to respond and the threshold value. For example:
Slow TNS server response=238 ms (> 200 ms)
The threshold value for this symptom can be changed. The default value is 50 milli-
seconds.
This symptom applies only to TNS servers. The symptom is recorded whenever the
server response exceeds the threshold for a client request. For slow responses to
initial log on, see the TNS Slow Connect Response symptom.
Diagnostic Details
__________________________________________________________________
Problem Description:
A response from the TNS server has taken longer than the threshold value to reach the
sender.
__________________________________________________________________
Probable Cause(s):
1. The server was very busy.
2. The network is overloaded.
3. The path to the sender from the receiver has long delays.
4. There may be an overloaded switch or router in the path.
__________________________________________________________________
Recommended Action(s):
1. Upgrade the server's CPU and/or memory.
2. Reduce the number of connections to the server.
3. Load balance your network.