Re: Which thread consumes the most CPU time?

Cesae Cruz <markaragnos17@yahoo.com.mx> wrote in message news:<1108757441.50900cc0934d3fed424cf28cb4865060@teranews>... > --0-1798347596-1108751895=:73324 > Content-Type: text/plain; charset=iso-8859-1 > Content-Transfer-Encoding: 8bit > > On AIX S.O. exists "nmon" command with "top" option process. > > On Informix "onstat -g ses SID" you can get de S.O. Process Match. > > > Christian Eriksson <c-eriks@algonet.se> wrote: > Hi! > > I'm looking for some diagnostics in situations when the database > server's processes (oninit) starts to consume more CPU time. > > Is it possible to see which thread have consumed the most of the > Database Server's CPU time for, let's say, the last 10 minutes? > > Regards Christian Eriksson > > > > --------------------------------- > Do You Yahoo!? > Yahoo! Net: La mejor conexi'n a internet y 25MB extra a tu correo por $100 al mes. > > --0-1798347596-1108751895=:73324 > Content-Type: text/html; charset=iso-8859-1 > Content-Transfer-Encoding: 8bit > > <DIV>On AIX S.O. exists "nmon" command with "top" option process.</DIV> > <DIV>&nbsp;</DIV> > <DIV>On Informix "onstat -g ses SID" you can get de S.O. Process Match.</DIV> > <DIV><BR><BR><B><I>Christian Eriksson &lt;c-eriks@algonet.se&gt;</I></B> wrote:</DIV> > <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">Hi!<BR><BR>I'm looking for some diagnostics in situations when the database<BR>server's processes (oninit) starts to consume more CPU time.<BR><BR>Is it possible to see which thread have consumed the most of the<BR>Database Server's CPU time for, let's say, the last 10 minutes?<BR><BR>Regards Christian Eriksson<BR></BLOCKQUOTE><p><br><hr size=1><b>Do You Yahoo!?</b><br> > <a href="http://net.yahoo.com.mx"><b>Yahoo! Net</b></a>: La mejor conexi'n a internet y 25MB extra a tu correo por > <a href="http://net.yahoo.com.mx/">$100 al mes</a>.<br> > --0-1798347596-1108751895=:73324-- > sending to informix-list Hi everybody, We can have the consumed cpu time, using the script (in dbaccess): database sysmaster ; set isolation to dirty read;select username,hostname,--connected, syssessions.sid, sysopendb.odb_dbname[1,10], sum(cumtime)/1000000 cpu_time from syssessions, sysopendb, sysseswts where 1=1 and syssessions.sid= sysopendb.odb_sessionid and sysopendb.odb_iscurrent = 'Y' and 1=1 and syssessions.sid=sysseswts.sid and reason='running' group by syssessions.sid,username,hostname,connected,sysopendb.odb_dbname having sum(cumtime)/1000000 > 1 order by 5 DESC; It may depends on how long you issued the command: onstat -z Best regards. R Ferronato

<snip> Does this require setting "WSTATS 1" in ONCONFIG? /Christian > > Hi everybody, > > We can have the consumed cpu time, using the script (in dbaccess): > > database sysmaster ; > set isolation to dirty read;> select > username,hostname,--connected, > syssessions.sid, sysopendb.odb_dbname[1,10], > sum(cumtime)/1000000 cpu_time > from syssessions, sysopendb, sysseswts > where 1=1 > and syssessions.sid= sysopendb.odb_sessionid > and sysopendb.odb_iscurrent = 'Y' > and 1=1 > and syssessions.sid=sysseswts.sid > and reason='running' > group by syssessions.sid,username,hostname,connected,sysopendb.odb_dbname > having sum(cumtime)/1000000 > 1 > order by 5 DESC; > > It may depends on how long you issued the command: > onstat -z> > Best regards. > > R Ferronato