Re: Intermittent Performance Problem - What does oninit do?

Your symptoms might suggest that for some reason you have longer than usual checkpoints occuring peiodically. Have you check/calculated you checkpoint durations and if they tie up with the busy spells? Do you have heavy disk activity during the busy spells. Alternatively, have you checked if you have any foreground writes? jziegler@wi.rr.com (Joel) wrote in message news:<87fc566d.0403080629.2f3ce518@posting.google.com>... > We have Informix V7.30 running on a SCO-Unix box. Several times during > the day, the response of the system goes in the tank. At these times, > sar indicates that there is 0% idle time. > > Our DB has around 2.5 million rows across about 30 tables. There is > another SCO-Unix box on the network with another Informix DB, and we > use synonyms to facilitate table reads across the network. > > I don't have a good tool to view the running processes, so I use ps > -ef to create an output file of the processes, wait several seconds, > and then do another ps -ef to a different output file. Using diff on > the two files, always indicates that oninit is the process getting the > most time. > > This seems to have gotten worse over time, e.g. this wasn't a problem > a year or two ago, so I don't know if it's indicative of a problem > related to the growing size of the DB, or some tweaking I need to do. > > I do Update Statistics on a regular basis, but this doesn't seem to > help. When oninit isn't gobbling up CPU time, the performance is > excellent. Again, this seems to happen during the day, unrelated to > user activity. > > What is oninit and what could it be doing? Does it do different things > at different times? > > Could this be a poorly timed DB administration task that is executing? > > As a side question, does anyone know of a good system monitoring tool > I can use for SCO? I've used top on HP-UX, but that doesn't exist on > my SCO boxes. > > Any help would be greatly appreciated. > > Joel