Craig, yeah it was easier when I worked for a dot-com :) These days, I work for an international company (you may have heard of them, it's Sony). Very rigid in who does what and who has input. Of course, it didn't help that I started here partway into the process and they had already decided on equipment. I screamed, they listened politely, told me that "it doesn't matter, we are on a SAN" and basically ignored me.
Rachel --- Craig Munday <[EMAIL PROTECTED]> wrote: > 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 <[EMAIL PROTECTED]> 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 <[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 > === 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: [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).
