pages used is greater than pages read

Posted in 2003

Chavan Koya — Sat, 02 Aug 2003 03:37:32 +0530 — source: Usenet: comp.databases.informix

Hello all, I have a question how the ( RA-pgsused ) > ( ixda-RA + idx-RA + da-RA ) below is the onstat -p how it is possible ? Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 625026 693973 3948101 84.17 17200 205909 49738 65.42 isamtot open start read write rewrite delete commit rollbk 1739382 0 0 1725784 0 0 0 13598 0 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 216.40 68.10 5 10 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 18085 0 18844 0 0 5 0 0 ixda-RA idx-RA da-RA RA-pgsused lchwaits 0 0 615916 615951 158 Any comments are appreciated. Thanks Chavan Koya _________________________________________________________________ Dress up your desktop! Get the best wallpapers. http://server1.msn.co.in/msnchannels/Entertainment/wallpaperhome.asp Just click here! sending to informix-list

↪ replying to Chavan Koya

The Big Potatoe — Mon, 04 Aug 2003 11:00:33 +0100 — source: Usenet: comp.databases.informix

Chavan Koya wrote: > Hello all, > > I have a question how the ( RA-pgsused ) > ( ixda-RA + idx-RA + > da-RA ) > below is the onstat -p > how it is possible ? > > > Profile > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached > 625026 693973 3948101 84.17 17200 205909 49738 65.42 > > isamtot open start read write rewrite delete commit > rollbk > 1739382 0 0 1725784 0 0 0 13598 0 > > 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 216.40 68.10 5 10 > > bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans > 18085 0 18844 0 0 5 0 0 > > ixda-RA idx-RA da-RA RA-pgsused lchwaits > 0 0 615916 615951 158 > > Any comments are appreciated. > > Thanks > Chavan Koya > > _________________________________________________________________ > Dress up your desktop! Get the best wallpapers. > http://server1.msn.co.in/msnchannels/Entertainment/wallpaperhome.asp Just > click here! > > sending to informix-list What are the settings for RA_PAGESand RA_THRESHOLD No potatoe, no food!

Related threads

Glossary

onstat