Tablespace striping across RAID-5

From: Chris Forlano <cforlano_at_nortelnetworks.com>
Date: Thu, 16 Sep 1999 14:28:32 +0100
Message-ID: <37E0F07F.EC4517FA@nortelnetworks.com>

I have a UltraSparc-333 running Solaris 2.6 and Oracle 8.0.5.

We have a 1GB transactional database (lots of reads/writes). I have four disks on RAID-5 broken up into three partitions. Does it make sense to stripe my tablespaces? Will I be helping, hindering, or not affecting my performance? Does it even make sense to break it up into partitions?

For example,

/disk1 (RAID-5)
/disk2 (RAID-5)
/disk3 (RAID-5)

create tablespace

datafile '/disk1/data01.bdf' size 20m
datafile '/disk2/data02.bdf' size 20m
datafile '/disk3/data03.bdf' size 20m

autoextend on next 50k
default storage (initial 50k next 50k pctincrease 1);

Thanks a million,

Chris
--
Chris Forlano
TMS Project Manager
Nortel Networks, Maidenhead
590 4342 (01628 434 342)
cforlano_at_nortelnetworks.com Received on Thu Sep 16 1999 - 08:28:32 CDT