Re: Waiting on condition problem.

>Here is onstat -g ses for a session which is waiting on condition for >more than >an hour. >How to find out the condition on which this is waiting ? >And how to make it run ? > > >Here is onstat -g ses for a session which is waiting on condition for >more than >an hour. > >18807 prodadm 140 erp-trai 1 131072 79552 > >tid name rstcb flags curstk status >28185 sqlexec 99cf4118 Y--P--- 34024 99cf4118 cond wait(netnorm) > >How to find out the condition on which this is waiting ? >And how to make it run ? > The netnorm condition is the condition that the engine thread "parkes itself" when it is waiting for the client to pass it somthing to do. This is either the networm (in tcp connections) or smwait(in shared memory connectsion). Madison Pruet