Fw: Opinions on usercpu & syscpu in onstat -p

Sorry, the total elasped time is 11.5 hours or 41400 seconds. TIA ----- Forwarded by Darren Jacobs/7001/Carmax on 04/07/2005 01:03 PM ----- Darren_Jacobs@car max.com Sent by: To owner-informix-li informix-list@iiug.org, st@iiug.org ids@iiug.org cc 04/07/2005 11:46 Subject AM Opinions on usercpu & syscpu in onstat -p Just wanted to get some opinions on the usercpu and syscpu meaning in the onstat -p output. I can't remember if I read in Lumbley's guide or not,but if usercpu exceeds the amount of lapsed time this indicates the system could benefit from more physical cpus. Below is an onstat -p output where total elapsed time is 67740 seconds. User cpu more than twice that at 150,951 HP N Class 6 Way 550's 6 gig Physical Mem. HPUX 11 9.40 FC2 IBM Informix Dynamic Server Version 9.40.FC2W4 -- On-Line -- Up 2 days 20:32:50 -- 3918780 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 58767865 124325277 12739374150 99.54 4592164 31893241 24004499 80.87 isamtot open start read write rewrite delete commit rollbk 7825834138 6479678 83176707 6822458070 178820294 1276025 720792 80860 488 gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs 0 0 0 0 0 0 0 ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes 0 0 0 150951.57 5282.00 143 429 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 3446881 2048 12220794081 23 0 512 480281 5784056 ixda-RA idx-RA da-RA RA-pgsused lchwaits 13697305 1729291 18192868 33137079 94700177 sending to informix-list sending to informix-list