Re: OLTP and RAID 5

"Paul Brewer" <paul_at_paul.brewers.org.uk> wrote in message news:3d8e2c90$1_2_at_mk-nntp-1.news.uk.worldonline.com...
> "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
>
>
>

I'm in the same situation. Both the original supplier and the distributor, an UK consultancy firm recently acquired by Atos Origin, however deny it is the application, and consistently try to blame our firm. Customer basically agrees with our findings, can't afford to sue the consultancy firm, as that would be the end of the customer.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address