list sql statements
John Smith wanted to list all SQL statements with cost, duration and CPU use, beyond onstat -g top and the statement cache. Andreas Legner suggested Query drill-down for retrospective analysis, or onstat -g ses/sql active or running with -r. Art Kagel pointed to the SQLTRACE feature; John's question about its low level impact was not answered.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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
------------------------------
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 ------------------------------
John: Check out the SQLTRACE feature. Art ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------
Related threads
- Posting from the Informix-list
- Migrating from IDS 9.40.UC6 to 11.50.UC3
- Ip for a network session
- questions onstat -g