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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Configuring Oracle with RAID and OFA

RE: Configuring Oracle with RAID and OFA

From: Craig Munday <Craig.Munday_at_ecard.com.au>
Date: Sun, 30 Mar 2003 16:53:37 -0800
Message-ID: <F001.00575F66.20030330165337@fatcity.com>


Rachel,

I guess it is much simplier in may situation because I do not have the challenges of working for a "very large company".

Good luck!! :-)

Cheers,
Craig.

-----Original Message-----
Sent: Monday, 31 March 2003 9:59 AM
To: Multiple recipients of list ORACLE-L

Craig,

I envy you your company. When you work for a very large company, which tries to save money via economy of scale, when you are not part of the production group but can only make suggestions, you don't get to make the decisions. It's not like I haven't tried to influence the decisions, but you need to have power or a position of authority from which to fight. I have no desire in the economy that exists in the US right now to say "do it my way or I'll quit". I'd rather repeat and document my recommendations and then be able to say "you'll need to change it to this as I told you before" (I'm not above saying I told you so)

Can you tell me exactly how you ensure you are part of the purchasing decisions? I'd love to find some new ways to be heard.

Rachel
--- Craig Munday <Craig.Munday_at_ecard.com.au> wrote:
> 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 <DWILLIAMS_at_LIFETOUCH.COM> 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.
> > dwilliams_at_lifetouch.com
> >
> > -----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: dwaynec_at_infotechfl.com
> > phone: 352.381.4521 fax: 352.381.4444
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Dwayne Cox
> > INET: dwaynec_at_infotechfl.com
> >
> > 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: ListGuru_at_fatcity.com (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: DWILLIAMS_at_LIFETOUCH.COM
> >
> > 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: ListGuru_at_fatcity.com (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: wisernet100_at_yahoo.com
>
> 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: ListGuru_at_fatcity.com (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: Craig.Munday_at_ecard.com.au
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>

=== message truncated ===



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: wisernet100_at_yahoo.com

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: ListGuru_at_fatcity.com (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: Craig.Munday_at_ecard.com.au

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: ListGuru_at_fatcity.com (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).
Received on Sun Mar 30 2003 - 18:53:37 CST

Original text of this message

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