Re: Informix session VS 'oninit' CPU usage

Posted in 2006

Davorin Kremenjas — Tue, 11 Apr 2006 09:07:24 +0200 — source: Usenet: comp.databases.informix

One more thing: you can use onperf to monitor session activity, it could help you a little. "Rupan3rd" <rupan.nospam.3rd@hotmail.com> wrote in message news:n2tYf.49175$nz4.46626@tornado.fastwebnet.it... > Hi Gurus, a question for you. And sorry in advance if it has been already > answered: I cannot find any previous reference to what I am looking for. > > I use Informix IDS 9.40.UC6 on Sun Solaris 9. > > Looking at the OS statstics, sometimes it can be observed that 'oninit' > process(es) corresponding to the configured CPU-class virtual processors, > use an high percentage of the server CPU. Such high CPU usage events are > short peaks and not the normal condition. > > Is there any (possibly scriptable) way to associate to each Informix > running > session the amount of CPU that is being used by it? > > The scope is to isolate the SQL statements that cause the high CPU usage > and > might need optimization. > > Thanx in advance, > Rupan3rd (Italy) >