Re: REPOST - Session resource usage stats.

Peter Tashkoff wrote: > ... > I am trying to develop a script that > will provide information on which > internal sessions are hogging the CPU. > Does anyone know of a way to obtain > session cpu usage information from > sysmaster? I can't find one. > I am able to read pagereads and > pagewrites, which gives a general idea > but would not always be exact. Post v5 engines no longer create sqlturbo processes for each user. Instead a few central processes (oninit) run the whole show. I think this means that the engine cannot associate cpu usage to any particular user. I was also looking for this information to be able to generate user usage reports, but the only thing to build on was the read/write counts like you mentioned. If I'm wrong, let me know. ---------------------------------------------------------------------- John H. Frantz Power-4gl: Extending Informix-4gl frantz@centrum.is http://www.strengur.is/~frantz/pow4gl.html