Tcp waits

Login or Register for Dates, Times and to Reply

 
Thread Tools Search this Thread
# 1  
Tcp waits

Hi Guys

I am running an Oracle database and most of my sessions are waiting for tcp.

Now, how do I check if tcp from the O/S level is servicing requests properly?

Please Help!!!

Thanks in advance...
# 2  
Quote:
Originally Posted by Phuti
I am running an Oracle database and most of my sessions are waiting for tcp.
What exactly do you mean by "waiting for tcp"? TCP establishes so-called "virtual channels" for communication. Think of them like telephone connections: you dial a number and once someone picks up at the other end the connection is established until the connection is dropped (one of the partners hangs up).

TCP connections (here is a difference to the telephone analogy) then go into a state which is called "FIN_WAITING" for some time until they are completely removed. You can influence the time this phase takes via TCP tuning options but in 99.9% of all systems this is not necessary.

So again: what is your problem and what do you mean by "waiting for tcp"?

I hope this helps.

bakunin
This User Gave Thanks to bakunin For This Post:
# 3  
Thanks Bakunin

I mean a code in the database that sends emails to our customers but these function is shows that the mails are in a queue.

Now, when I investigate the database I could see that there is a delay from the exchange server and I always see one connection from smpt I see one and it takes about 10-15 minutes.

I need help in troubleshooting these delays...

Thanks in advance...
# 4  
OK, the picture is clearer now, but still not entirely conclusive:

Quote:
Originally Posted by Phuti
and I always see one connection from smpt I see one and it takes about 10-15 minutes.
I suppose by "smpt" you mean "SMTP", which is "Simple Mail Transfer Protocol". This is a specialized protocol (based on the TCP protocol as a means of transport) to transport mails between a client and the MTA as well as between MTAs. (If you cannot make sense of the term MTA: here is a short introduction).

If you maintain an Exchange Server (which is a software as close to a real MTA as Microsoft was able to program it) it perhaps uses SMTP transmissions to send and/or receive mails, both locally and to/from outside. Depending on the volume of data to send may or may not take several minutes to do so.

How about describing your environment and your problem a bit more completely so that we can provide concrete help instead of giving you some general information, hm?

I hope this helps.

bakunin
This User Gave Thanks to bakunin For This Post:
# 5  
Thanks for the reply...

This could be due to the TCP server being slow. How can test the tcp performance?

I also require help with the NIC config, just to check if its configured properly.

Please guide as to how can I see if the NIC is properly configured.

Thanks in advance...
Login or Register for Dates, Times and to Reply

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script that waits for process to complete

Hello, I am in need of running an executable provided by a vendor that basically syncs files to a db. This tool can only be run against one folder at a time and it cannot have more than one instance running at a time. However, I need to run this tool against multiple folders. Each run of the... (5 Replies)
Discussion started by: vipertech
5 Replies

2. Solaris

Too much TCP retransmitted and TCP duplicate on server Oracle Solaris 10

I have problem with oracle solaris 10 running on oracle sparc T4-2 server. Os information: 5.10 Generic_150400-03 sun4v sparc sun4v Output from tcpstat.d script TCP bytes: out outRetrans in inDup inUnorder 6833763 7300 98884 0... (2 Replies)
Discussion started by: insatiable1610
2 Replies

3. AIX

AIX CPU waits

Guys, I have a question - when nmon reports a sizeable %CPU wait, does that mean - 1) IO operations are slowing CPU down, OR 2) paging slowing the CPU down, OR 3) one cant tell?? I thought the nmon documentation clearly suggested that CPU waits reported in nmon were from disk... (4 Replies)
Discussion started by: getback0
4 Replies

4. Shell Programming and Scripting

Script that waits until a call is done

Hi all, I have a script that checks for the existence of files in a directory. Problem is, if a file suddenly appears, I need to move it to another directory and then call another program that does not import routines (within our DBMS). Now, this script is ever running and uses the sleep... (3 Replies)
Discussion started by: gseyforth
3 Replies

5. Programming

Runtime.getSystem.exec() function waits for child

Runtime.getSystem.exec() waits for child process to complete .. I do not want to wait for the child process to complete ..what is the option which has to be used ? (2 Replies)
Discussion started by: shafi2all
2 Replies

6. Shell Programming and Scripting

shell script executes program, but waits for a prompt

Sorry, newbie here. I have the following shell script which basically executes the sh-n-body.i686 program a specified number of times. However, before the sh-n-body.i686 begins its calculations it prompts for input from the user. In this case the user would have press ". return" and... (7 Replies)
Discussion started by: lionatucla
7 Replies

7. IP Networking

ftp waits for longer time to reply

If i fire followin command on unix (linux/solaris) and windows ftp serverX where serverX is not in the network, it takes more time to get reply on unix(3-4 mins) rather windows(1 min), can anybody tell me why this happens? and how to reduce this time span? (1 Reply)
Discussion started by: amolwar
1 Replies

8. IP Networking

TCP/IP in c (unix)

I have written a client receive (TCP/IP) program which is up all the time. It connects to the server during Beginning of the day and stays alert and reads a message whenever one comes in. the problem is after receiving a message, the client_receive program is getting a message with zero bytes.... (0 Replies)
Discussion started by: Rajeshsu
0 Replies

9. IP Networking

Tcp\ip

I have written a TCP/IP client and server program. The client sends a message to the server and then the server sends a file back to the client. The client reads the buffer and stores it another file in the client side. I need to know what are the various exceptions that I need to handle in... (0 Replies)
Discussion started by: Rajeshsu
0 Replies

10. Cybersecurity

Tcp/ip

!HELLO , What is the maximum number of hosts on a TCP/IP internet? plz can u help me. :rolleyes: (2 Replies)
Discussion started by: smdakram
2 Replies

Featured Tech Videos