Re: Question: UPDATE STATISTICS and CPU usage

Posted in 1998

J Lusty — Fri, 6 Feb 1998 16:41:05 -0600 — source: Informix-list mailing list archive (1991-1998)

Georg Winkens wrote in message <6b7e1u$7kn$1@news.xmission.com>... | <snip> |Could it be that the Update Statistics statement uses up all the CPU |power? <snip> While it is running, open another Telnet session and run "top". If the %CPU column for any "oninit" commands reads close to 100%, then you will know. Here's a sample output of our single CPU HP box. Oninit is the busiest process, even though it is only using 1.6% of the CPU. System: hp01 Fri Feb 6 16:36:32 1998 Load averages: 0.54, 0.49, 0.38 115 processes: 114 sleeping, 1 running Cpu states: LOAD USER NICE SYS IDLE BLOCK SWAIT INTR SSYS 0.54 0.2% 0.0% 0.2% 99.6% 0.0% 0.0% 0.0% 0.0% Memory: 7280K (4068K) real, 25008K (17916K) virtual, 6904K free Page# 1/9 TTY PID USERNAME PRI NI SIZE RES STATE TIME %WCPU %CPU COMMAND ? 3090 informix 156 20 5216K 352K sleep 62:44 1.60 1.60 oninit p1 8887 informix 178 20 1988K 284K run 0:00 0.41 0.40 top