Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
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)
>
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.