Re: Question About oninit
Posted in 1998
First things first, you must remember that "oninit" is the database
engine. It is supposed to take all of the CPU possible to efficiently
and expeditiously answer your database requests.
If you use onstat -g glo, you can get the pids of the oninits. This
ouput will also give you the VP Class of the oninit. CPU VPs should get
a lot of time. This is where your database requests are serviced.
You neglected to say if this were an OLTP or DSS environment. Either
way, OnLine is designed to take all the CPU you throw at it and utilize
it. After all, you did pay a lot of money for your hardware, shouldn't
the database engine take advantage of it?
If your systems administrator really is getting upset over OnLine taking
80% of the available CPU time, you can reduce the amount of CPU VPs
(unless you are on a uni-processor). This will reduce the amount of CPU
intensive processes on your machine. Another cause could be poor disk
configuration, that is, all of your data requests maybe on one or two
drives. This could cause wait on I/O (wio) to be high. Some system
monitoring tools report wio as CPU utilization time, some report it as
idle time.
Dave Proksch
Advanced Technology Group
Informix Software, Inc.
#include <disclaimer.h>
In article <6a3ma1$q13@bgtnsc01.worldnet.att.net>,
conniec1@worldnet.att.net says...
>
>I seem to remember some discussion about an oninit process h
>ogging CPU
>resources. I am running Online Dynamic Server 7.23 on an HP
>9000 system
>and seem to have that problem. This oninit process sometime
>s goes up to
>as much as 80% or more and stays there for several minutes.
> It's making
>our system administrator crazy! The PPID of this oninit is
>1, which I also
>seem to recall from the earlier posting. There is no one id
>entifiable
>program
>that would seem to be taking all the CPU.
>
>Is there anything that can be done to lower this percentage?
>--
>Connie Cocanougher