Re: pages used is greater than pages read
RA_PAGES 50
RA_THRESHOLD 20
----- Original Message -----
From: "The Big Potatoe" <TBP@Nospam.Nothere.Co.Uk>
To: <informix-list@iiug.org>
Sent: Monday, August 04, 2003 5:00 AM
Subject: Re: pages used is greater than pages read
> 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_PAGES> and
> RA_THRESHOLD>
> No potatoe, no food!
>
>
sending to informix-list