Re: What's happening inside the oninit process ?

> Dirk Moolman wrote: > > Hallo everyone, I'm not sure how to word this question. > > Regarding the oninit processes running on our machine, is it possible > to see inside the process to see which users are causing the oninit to > do so much work ? > > One thing we do is to run "top" to identify the top processes on the > server. The oninit processes sit right on top - where they should > be, but they don't always do the same amount of work. If we have > badly written code, it will still be the oninit doing all the work, so > how do I trace the problem from the oninit back to the "bad program" / > user ? Use top to identify rogue applications. Of course the DB work is all done by threads, so no processes except oninit, which should be on top. > All I see right now is a busy system and oninits doing alot of work. > I would love to be able to drill down further and say to everyone, > "here is the program slowing your system down". If DBA with Informix was easy, everyone would be doing it! :-) Try: onstat -g act -r 1 This will give you thread numbers that you will have to track back to session numbers. > I would say that we are at a point where we cannot add more resources > to the server, so we are now trying to identify bad programs, etc. to > increase performance. Is there such a thing as a bad program, or are there just bad programmers? ;-)) Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+