Re: OLTP and RAID 5

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:a20d28ee.0209180301.1e35c5c0_at_posting.google.com...
> ora_geek_at_yahoo.com (Ora) wrote in message
news:<fa5d6718.0209172252.4cbd0b7b_at_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.
> >
> > 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.
> >
> > My basic doubt is can an OLTP system and RAID 5 a good combination.
> >
> > TIA.
> >
> > OrA
>
>
> It isn't. RAID-5 has a write penalty associated, and is commonly
> discouraged for OLTP applications. There have been many posts in this
> group discussing this at length. Instead of repeating this discussion
> I recommend you use the archives at http://groups.google.com to get a
> clear picture.
>
> Regards
>
> Sybrand Bakker
> Senior Oracle DBA

Sybrand,

True enough, but 98% is the app and the SQL it submits. I agree with your earlier posting in this thread; if the application isn't ours, there are a few things we can do, but not many. Sorry if this sounds irritable; it isn't meant to be. I've had a bad day trying to rescue a problem which is caused by the application design being a heap of shit. The DBA's are supposed to run around the touchlines at 100 mph fixing things after the event, yet are not allowed to join in the game. (Rant over).

Regards,
Paul Received on Sun Sep 22 2002 - 13:15:11 CDT