Re: Excessive number of oninit processes

Tauren Mills wrote: > > I have an Informix Online Workgroup Server 7.12.UC1 with 7 very small > databases running on Solaris 2.5.1 (Sparc). > > When the database starts up, it spawns 25 oninit processes that each use up > 17MB of RAM. As time goes on, these processes grow in size up to about 22MB > each. Only one or two of these processes are getting any CPU time. You will probably find that the 17MB is the TOTAL memory allocated to the database server. This is not necessarily allocated to EACH process. Use onstat -g seg to see how much memory is allocated. If allocation is growing then it is possible that virtual segments are being created dynamically. These should also show up in your message log. > I am running into memory/swap space problems on this machine. Why are there > so many of these processes? How do I get rid of some of them? The number of oninit (VP) processes is determined by your configuration. Specifically check the number of CPU VPs and AIO VPs. You shouldn't have more CPU VPs that physical CPUs. You should tune the number of AIO VPs to the number of disks. If you are using KAIO you only need 1 or 2 AIO VPs. Check for KAIO with onstat -g ioq. > Can I remove some while the database is running? Yes, use onmode -p..... > Can I make it so that so many do not > get created when the database starts up? Yes, change your configuration parameters. > If possible, please include a reply to tauren@groovee.com. Sure, but only because I have a 'Reply All' button. :-) Hope that helps, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.informix.com/idn |///// / //| |http://www.iiug.org +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 838250 2325 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+