Re: OLTP and RAID 5

From: tingl <tlam15_at_hotmail.com>
Date: 18 Sep 2002 11:15:55 -0700
Message-ID: <f487699f.0209181015.467f59ed@posting.google.com>

> I have inherited an Oracle 8i OLTP Database on Compaq / NT server ,
> with 6 Disks of 18.5 GB Each , which has RAID 5 implemented at the
> Hardware Level.
>

Congrats :)

> All my logfiles , control files and Datafiles are all seemingly in one
> location .
>
> With RAID 5 , is it true that I need not distribute the files on
> various disk to reduce IO contention - as the files are already
> striped on all the disks.
>

That's correct.

> My basic doubt is can an OLTP system and RAID 5 a good combination.
>

In general it's okay for a pure OLTP database. If you are getting acceptable performance, I wouldn't worry about it. You don't have many other options with only 6 disks anyway. Received on Wed Sep 18 2002 - 13:15:55 CDT