Oninit cdi / Archive
Talk to an expert →

which query consumes much CPU ?

Posted in 2006

Topics: General Discussion

Cristiano Torres — — source: Usenet: comp.databases.informix

we are using Informix 9.4 UC2 with Linux, but anytime the database server show (TOP) column idle 5%. How can I know which session a lot of CPU in my database ? Atenciosamente, Cristiano Torres

↪ replying to Cristiano Torres
Art S. Kagel — — source: Usenet: comp.databases.informix

Cristiano Torres wrote: > we are using Informix 9.4 UC2 with Linux, but anytime the database server show (TOP) column idle 5%. > > > How can I know which session a lot of CPU in my database ? I've got my suspicions. Please post your ONCONFIG file, onstat -g ses output, and the lines from TOP containing the high CPU usage oninit processes. Art S. Kagel

Related threads