RE: Find a query using very CPU
This works for me on sysmaster Database.
select avg(sqx_estcost) avg_estcost, count(*) num, sqx_sqlstatement
from syssqexplain
group by 3
having avg(sqx_estcost) > 100
order by 1 desc;
only looks at currently running sql on database. Pinched it off the net
somewhere so cannot give anyone any credit for it
a it don't remember where it was.
________________________________________________________________________
________
If you can find such a process in OS enviroment with Tool2, you may
also do the same.
1. find the process (onstat -g ses , or using SMI db)
2. find it with Tool2
On 7/6/06, Cristiano Torres <cristiano@wpd.com.br> wrote:
Hello,
someone know How can I find query using very CPU the Informix ?
Thanks
Cristiano
________________________________________________________________