Showing results for 
Search instead for 
Did you mean: 

fin_wait_2 timeout

fin_wait_2 timeout

We have a whole bunch of Oracle forms creating socket comms to our HP-UX server in order to start server side C batch programs. We have experienced no problems until recently.
Occasionally (once in every 6 or so runs)one particular problematic form initiates the socket connection and starts up the C program on the server. But for 6 - 8 minutes or so appears to be doing no work and then suddenly returns the socket acknowledgement and then proceeds as usual.
To solve the problem (for a while) I set the fin_wait_2 timeout value from it's default value of 0 to 30000 ms and then after 30s I reset it back to 0. The result is that the number of sockets in fin_wait_2 state reduce from between 200 and 400 down to around 90 or so.
What is wrong in the environment that could cause this behavior? I am not sure whether I should permanently set the timeout value or is the problem in the form or C batch program?
No other forms/batches "appear" to be suffering from this problem.

Any help would be appreciated.
Kind Regards
Steven E. Protter
Exalted Contributor

Re: fin_wait_2 timeout

Shalom Graham,

I would look into how this form is coded first. If there was a general problem with Oracle forms, there would be consistent behavior with other forms.

I do not believe that chancing the network configuration is a good answer here.

Steven E Protter
Owner of ISN Corporation