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.
> [url]http://server1.msn.co.in/msnchannels/Entertainment/wallpaperhome.asp[/url] Just
> click here!
>
> sending to informix-list
What are the settings for

RA_PAGES
and
RA_THRESHOLD

No potatoe, no food!