Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Raid performace issues (Raid 5 vs. Raid 0+1) with database files

Re: Raid performace issues (Raid 5 vs. Raid 0+1) with database files

From: Jeff Hunter <jeffh_at_btitelecom.net>
Date: Wed, 1 Sep 1999 13:10:39 -0400
Message-ID: <37cd5e43@defiant.btitelecom.net>


Just FYI, the A5200 is not a Hardware based RAID unit; it is all software based RAID...

Martin Hepworth wrote in message <37CCD323.5D644363_at_usa.net>...
>NetComrade wrote:
>>
>> Hi folks,
>>
>> We are thinking to place one of our DB's on a Sun Storedge 5200 and
>> Sun Enterprise 4500.
>>
>> Since we have a web-based OLTP environment, well, actually mixed,
>> since we have major updates running at nights against most of the
>> data, I thought that RAID-5 is not great, since during the day there
>> are a lot of small reads/writes.
>> I was thinking about 0+1 on datafiles with actualy data, but I am not
>> sure whether I need to mirror the TEMP tablespace or whether I should
>> place the REDO logs on the mirror.
>>
>> Any advice would be appreciated.
>>
>> Thanx
>> ---------------
>> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417
>> AOL: NetComrade ICQ: 11340726 remove NSPAM to email
>
>HI
>Well I'm doing similar and am about to test various combinations...right
>now I'm going for 2x RAID5 sets, 1 for the data and 1 for the redo logs.
>With the 5200 you have hardware RAID5 so writing should be nice and
>fast, not that much different from 0+1, and RAID 0+1 is probably not
>justifiable for extra tiny perf gain agianst cost of disks.
>
>But like I said I'm going to test a few combinations and see what
>happens. If you want to pool test results contact me via email.
>
>Martin
Received on Wed Sep 01 1999 - 12:10:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US