Hello

Usually i use onstat -g top to figure out the most consuming CPU sessions, but i need also to list all sql statements (not onstat -g stm with only thos on cache), with there costs, duration,

prefectly , these informations  (sessid, sql statement, cost, duration , cpu consuming)


Thanks in advance

------------------------------
John Smith
------------------------------

#Informix

For retrospective consideration, Query drill-down probably is what you're after.

For monitoring and investigating an ongoing cpu consumption problem, you could use 'onstat -g ses active' or 'onstat -g ses running', possibly with -r option (which now even allows sub-second and zero-wait repeat rates), providing immediate insight into what SQL it is that's keeping your instance so busy.  (Instead of 'ses' also 'sql' is possible, to avoid all the session information.)

------------------------------
Andreas Legner
------------------------------

Original Message:
Sent: Fri September 16, 2022 04:40 AM
From: John Smith
Subject: list sql statements

Hello

Usually i use onstat -g top to figure out the most consuming CPU sessions, but i need also to list all sql statements (not onstat -g stm with only thos on cache), with there costs, duration,

prefectly , these informations  (sessid, sql statement, cost, duration , cpu consuming)


Thanks in advance

------------------------------
John Smith
------------------------------

#Informix

Hello and thanks :)
i totally forgot sql trace, but can i activate it to have the informations without impacting users activitiy ? sqltrace= low is sufficient ?

------------------------------
John Smith
------------------------------

Original Message:
Sent: Fri September 16, 2022 05:37 AM
From: Andreas Legner
Subject: list sql statements

For retrospective consideration, Query drill-down probably is what you're after.

For monitoring and investigating an ongoing cpu consumption problem, you could use 'onstat -g ses active' or 'onstat -g ses running', possibly with -r option (which now even allows sub-second and zero-wait repeat rates), providing immediate insight into what SQL it is that's keeping your instance so busy.  (Instead of 'ses' also 'sql' is possible, to avoid all the session information.)

------------------------------
Andreas Legner

Original Message:
Sent: Fri September 16, 2022 04:40 AM
From: John Smith
Subject: list sql statements

Hello

Usually i use onstat -g top to figure out the most consuming CPU sessions, but i need also to list all sql statements (not onstat -g stm with only thos on cache), with there costs, duration,

prefectly , these informations  (sessid, sql statement, cost, duration , cpu consuming)


Thanks in advance

------------------------------
John Smith
------------------------------

#Informix

John: 
Check out the SQLTRACE feature.

Art

------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
------------------------------

Original Message:
Sent: Fri September 16, 2022 04:40 AM
From: John Smith
Subject: list sql statements

Hello

Usually i use onstat -g top to figure out the most consuming CPU sessions, but i need also to list all sql statements (not onstat -g stm with only thos on cache), with there costs, duration,

prefectly , these informations  (sessid, sql statement, cost, duration , cpu consuming)


Thanks in advance

------------------------------
John Smith
------------------------------

#Informix