> If you've got an e10000, that's a lot of horsepower.  Before recommending
> anything, I'd want to know a little more about what you guys are up to.
Can
> you tell me:

> Is the application OLTP/DSS?
> How many users doing what sort of activity?
> How much data?
> 28CPU/20GB Ram - ok
> How many 'disks' - ok you've got raid 5, but how are those disks
configured?
> Send me onstat -a and oncheck -pe outputs

> For starters.

> cheers
> j.

> ----- Original Message -----


> Sent: Monday, October 01, 2001 7:42 AM
> Subject: Do i need to increase RA_xx parameters?

> > Dear Informix Community,

> > I have the following onstat outputs:

> > Informix Dynamic Server 2000 Version 9.21.FC4     -- On-Line -- Up
> 03:59:36 -- 5126144 Kbytes

> > Profile
> > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
> > 9119308  62087177 674286865 98.65   1446173  2724607  9490173  84.76

> > isamtot  open     start    read     write    rewrite  delete   commit
> rollbk
> > 643153602 32531343 30892874 439061200 1300891  767955   37420    279198
> 60159

> > 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
> > 9        0            0        120380.10 16773.26 41       82

> > bufwaits lokwaits lockreqs deadlks  dltouts  ckpwaits compress seqscans
> > 1122116  7508     546211790 1914     0        4294     448623   228280

> > ixda-RA  idx-RA   da-RA    RA-pgsused lchwaits
> > 1862503  373399   983593   3109602    2977112

> > I have 228280 seq.scans in 4 hours (which means 15 per second.)

> > I want to know whether these sequental scans are good or bad and i query
> sysptprof table.

> > I want to ask , if my sequental scans are good do i need to increase my
RA
> parameters?

> > The number of  diskreads are:9,119,308 and number of RA-pgsused :
> 3,109,602 (nearly 1/3) . and the totals of ixdaRa,idxRa,daRA is
> > 3,219,495.  Do i need to increase RA pages?They are currently in default
> values.

> > Kind Regards,
> > hope

> > ==================================
> > Poster's IP address: 212.15.12.4
> > Posted via http://www.***.com/
> > Linux Programmer's Site