process wait at stream

[Printaporn_1]

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,

[Brian Hackley · Accepted solution]

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

[Printaporn_1]

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