session(s) taking the most cpu ressources
John Smith asked how to find sessions using the most CPU. Vladimir Kolobrodov suggested onstat -g top on current servers, and onstat -g cpu or filtering onstat -g ath output on older ones. Mike Walker supplied a sysmaster query joining syssessions, systcblst and sysrstcb ordered by cpu_time. John thanked them; solved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hello please, is there a way to identify sessions that taking the most part of a CPU ressources ? regards ------------------------------ John Smith ------------------------------ #Informix
Current server:
onstat -g top
( see 'https://www.ibm.com/docs/en/informix-servers/14.10?topic=ogmo-onstat-g-top-command-print-top-consumers-resources'; )Previous - in real time you can use "onstat -g cpu", or observe / filter (continuous) "ath" output (UNIX/Linux):
onstat -g ath -r 3 | egrep 'Informix|running'I am sure someone here has a script/sql for SMI tables too ...
------------------------------
Vladimir Kolobrodov
------------------------------
Depends on your Informix version, but try this:
dbaccess sysmaster <<!
select first 10
s.sid ,
s.username ,
s.uid ,
s.pid ,
s.hostname ,
t.tid,
t.name,
t.statedesc ,
t.statedetail,t.cpu_time
from syssessions s,
systcblst t,
sysrstcb r
where t.tid = r.tid AND s.sid = r.sid
order by t.cpu_time desc;
!
------------------------------
Mike Walker
xDB Systems, Inc
www.xdbsystems.com
------------------------------
Thank you so much :) ------------------------------ John Smith ------------------------------