Re: 7.22 onstat -u flags

On Thu, 13 Mar 97 05:43:05 GMT, rferdy@kuwait.net (Rudy Fernandes) wrote: >>> My question: the onstat -u output has a "Y" in the first slot of the >>> flags column for _all_ my client processes almost all the time. >>> >>> The doc just says that a "Y" means that the process is waiting on a >>> condition. What condition???? >>> >>> Does it mean waiting in the sense that it is being held up by >>> something, or waiting in the sense that it is idle and has nothing to >>> do?? > >Idle, nothing to do. >For example, if the user is in the midst of data entry of a field, the >server thread has no work and would be 'Y'. >At the press of the Enter key, if a validation is done using the database, >there would be an instant (hopefully!) during which the Y could change >to B,C,G,L,S before reverting back to Y. >In an OLTP, it should be 'Y' most of the time. In an active DSS environment, >you will find many less 'Y's. Thats a relief. >P.S. I owe you one. I have been looking for a way to find out which user >was 'hogging' a bogged down system and your query set me in the right >direction. Hey, no problem. :) Thanks for the info, Rudy cheers allen