Re: Oracle in mirror'd or RAID'd storage arrays (SUN)

Nigel,
We have 3 SSA102 arrays connected to Sun1000e servers, running Oracle 7.1.16 and some 7.2.3, each server has multiple instances running on it.

We have no performace problems with the Arrays, any bottlenecks we get are network/memory/cpu related.

There are some tools with Veritas you can use to see how the array is going. There is a GUI performance tool called "vxva" - select "analyse all" to see what disks, subdisks and volumes are being hit.

Use "vxstat" to get overall i/o figures for the volumes. Our database volumes and archive re-do log volumes are all RAID5 and perform well. We use mirrors for online re-do logs and rollback segements.

Some care was used in setting up the array to make sure each disk in a volume was on a separate internal controller, and load balanced over spindles and controllers. I have added an extra column at the end: M for Mirror, 5 for RAID5 and S for stripe. The ....arch volumes hold archived re-do logs, ....db are Oracle data and indexes - yes we have the data and indexes on the same volume and get less than 30ms writes with RAID5.

Here are the actual stats for one of our boxes:
># uptime

 8:39am up 58 day(s), 17:25, 0 users, load average: 0.34, 0.17, 0.20
># vxstat

                        OPERATIONS           BLOCKS        AVG TIME(ms)
TYP NAME              READ     WRITE      READ     WRITE   READ  WRITE 
vol vol-ACParch     200043    496987   5416067   8620248    8.7   25.3 R5
vol vol-ACPdb      5698091   1884507 108295660  16003892    8.3   23.0 R5
vol vol-ACPrbs      856252    526450  14088691   4468316    4.5    4.9 M
vol vol-ACPredo     185609    547077   5470527   5978900   10.7    4.7 M
vol vol-AppSW       419076   4568741  10042876  77221944   14.8   85.3 R5
vol vol-FCRarch    4473305  13833529 109582665 231390482    8.7   21.3 R5
vol vol-FCRdb     52326989   8539468 1477327350 129332700   10.3   26.1 R5
vol vol-FCRrbs     2716458   2962644  43538623  46320740    4.2    4.6 M
vol vol-FCRredo    1742656   9531407  77596938 118458684   15.0    3.8 M
vol vol-OracleSW   4738866   1000486  70153269  12501308    8.1   85.1 R5
vol vol-exports    9832279   1684141 267859906 169331134    5.5    4.8 S
vol vol-homes       284485    164456   2561534   2532930    7.9   79.5 R5
vol vol-patrol      787684   1634232   9771002  21053867    6.6    7.7 S

Regards,
George Dau
gedau_at_mim.com.au Received on Tue Dec 24 1996 - 00:00:00 CST