Re: 7.22 onstat -u flags

In article <3326ED29.32C7@worldaccess.nl>, Gert van Eck <gvaneck@worldaccess.nl> wrote: >Allen W. Jantzen 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. >> >> It is normal to see all these all these "Y"'s in the first flag slot?? >> Or should this slot be empty most of the time?? In an OLTP, it should be 'Y' most of the time. In an active DSS environment, you will find many less 'Y's. 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. Cheers, ---------------------- Rudy Fernandes (ICP) GIC, Kuwait ----------------------