Rachel, There seems to be something inherently wrong with a DBA not getting to determine the layout of their disks.
I too have experienced this problem in the past and have found that it is difficult to achieve change once large sums on money have already been committed. These days I ensure that I am involved in the purchasing decision from the out set - its easier to get what I want that way. I use this technique with developers as well. If I am lucky enough to see the beginning of a development project, I ensure that I set standards for database development when the developers are setting other coding standards for themself. It helps developers understand what I expect of them and also gets their buy-in. I've found that developers like standards more than me trying to tell them what is wrong with their code after they have puts months of work. - developers tend to get emotionally attached to what they create :-) It is also a little unfair to impose standards retrospectively which threaten their deadlines. I'm sure other DBAs have experienced the similar things, and I'd be interested in how they have tried to solve their problems. Cheers, Craig. -----Original Message----- Sent: Friday, 28 March 2003 1:54 AM To: Multiple recipients of list ORACLE-L Dennis, Sometimes you don't have the option to decide if you are using a single RAID set or not. At my last job I was told "hey, we have 375GB of space for you -- and it's RAID-5". I was not asked if I wanted it configured that way, I was not listened to when I protested. So the alternatives I faced were a) run my database on RAID-5 and do the best I can or b) quit because I refused to run a database on RAID-5 Option b seemed a little extreme. You really can't make pronouncements like "you shouldn't run a production database on a single RAID set" because sometimes you have to. Oh yeah -- the database ran fine, we had no performance problems and we DID have good backups. Rachel --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > Dwayne > So you have a single RAID set, or 5 separate devices? You might > have a > test database on a single RAID set, but you shouldn't do that in > production. > First, multiple control files on separate devices. Redo should write > to a > non-RAID device since it continuously writes. Past that it depends on > how > much performance this system requires. > Gaja and Kirti explain this nicely in Oracle Performance Tuning > 101. > > Dennis Williams > DBA, 40%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -----Original Message----- > Sent: Thursday, March 27, 2003 6:59 AM > To: Multiple recipients of list ORACLE-L > > > Hi all, > > I am configuring a system for use with Oracle and am confused on the > concepts > of RAID and OFA, specifically how they work together. > > I inherited a system that is a RAID 5 utilizing 5 disks. Oracle8i > (8.1.7) > is > currently running on it. The database is setup on one disk (data > files, > control files, redo logs, etc.). > > I understand that striping spreads the info out across all the disks. > That > being true, is it necessary to put the redo logs, rollback segments, > etc on > sepaparte disks ala OFA? > > Since the database is not in production yet, I have time to make > these > changes > (not to mention we are planning to redo the setup with Red Hat > Advanced > Server and upgrade to Oracle9i). > > Thanks in advance for your help. Feel free to point me to additional > reading > materials that will clarify this for me. > > Dwayne > > -- > Dwayne Cox > Corporate Database Administrator > Info Tech, Inc. > 5700 SW 34th Street, Suite 1235 > Gainesville, FL 32608 > > email: [EMAIL PROTECTED] > phone: 352.381.4521 fax: 352.381.4444 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Dwayne Cox > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > __________________________________________________ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Munday INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
