topic Re: process wait at stream in Operating System - HP-UX

process wait at stream

Printaporn_1 — Thu, 08 Mar 2001 11:32:26 GMT

Hi,

I am running Oracle workflow process , in other site it take less than 1 mins , but in my N-Clasee 4 CPU 4GB Ram take more than an hour !!
I use glance and found that the process was spawn many process oracle.... and all of them waiting for stream ?

Any idea ?

Thanks in advance,

Re: process wait at stream

Brian Hackley — Thu, 08 Mar 2001 14:25:49 GMT

Hello,
At 11.0 waiting on Streams means that the process is blocked on a socket operation. So its most likely waiting for the other end of the TCP connection to do something. Use GLANCE or a debug tool such as truss/tusc to find out what the process(es) are doing. From that point you should be able to determine the next steps to take.

You should also verify other aspects of networking are working OK, e.g. telnet/ftp/NFS and that if you are using 100BaseT that the N4000 and the network switch(es) are both configured the same. lanadmin -x (PPA) will tell you the settings for 100BaseT. e.g. for lan1 lanadmin -x 1 .

Hope this helps,
Brian Hackley

Re: process wait at stream

Printaporn_1 — Fri, 09 Mar 2001 02:08:33 GMT

Thanks for the answer , that's clear.
we can fix the problem by change oracle script not to run the process in parallel.
Then it may not need for socket communication.
Thanks