SUMMARY: RE: REPOST - Session resource usage stats.

My original question is below sig. It seems confirmed that it is not possible to *directly* gain CPU usage information for sessions in 7.x as they are managed through the oninit processes and nothing that I have been able to discover in sysmaster gives you this info. I have been running with a combination of scripts to detect high cpu usage (like top in solaris) and high read/writes within the RDBMS, available from sysmaster:sysuserthreads. This combination turns out to be reasonably successful in identifying resource pigs. These are reasonably easy to construct but if anyone wants a copy they can e-mail me. Thanks to Sujit Pal <spal@watson.den.csci.csc.com> and John H. Frantz <frantz@centrum.is> for their replies. -- -- Peter Tashkoff <tashkop@kiwi.co.nz> NZ Kiwifruit Marketing Board Usual disclaimers apply. This posting may not be used by any party to vilify another. Original Posting as under; > ... > 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.