onstat -p Funny
Posted in 2003
OS: Solaris 9
Everything is working fine, no problems as far I can tell then
all of a sudden our monitoring picks up a read cache drop and
I get the following onstat -p. The DBserver is for a website,
traffic levels haven't changed, and there are no background jobs,
and I'm seeing very little disk activity but the cache still
reads 0%. The stats have not be cleared down
Any ideas
informix: onstat -p
Informix Dynamic Server Version 9.40.UC1 -- On-Line -- Up 17 days
22:08:25 -- 2493440 Kbytes
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
194114421 312676058 177660467 0.00 39720009 67800818 485224646 91.81
isamtot open start read write rewrite delete commit
rollbk
827519294 710678029 1555618190 1316756590 153621187 53758451 29505132
19735797 4021
gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
26 0 0 0 0 0 0
ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
7 0 0 699372.01 77315.73 1378 3785
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
10238808 14188 2996100352 0 0 1737 2063363 1506506
ixda-RA idx-RA da-RA RA-pgsused lchwaits
9209658 16758888 27476541 51934399 6011213
--
Paul Watson #
Oninit Ltd # Growing old is mandatory
Tel: +44 1436 672201 # Growing up is optional
Fax: +44 1436 678693 #
Mob: +44 7818 003457 #
www.oninit.com #