Now see... as one new to the world of Apps DBA, I looked at her list, and realized that it was the other kind of applications... not "Oracle Applications".... although from my experience network support, client support, "whipping" post, IT team member (possibly team leader), self driven, office coffee maker (mostly because you WANT coffee, and are there before and/or after everyone else), consumer of various liquids... apply across the board.
I also think... Ron... that being an apps dba requires not only a dedicated and investigative mind set... but a warped mindset... one in need of serious analysis... is required of apps dba. There is no other animal QUITE like Oracle Applications... it kind of reminds me of the dragon from Homer... the one that grew extra heads when you cut one off... but this one seems to know when you are thinking of cutting off a head, and it grows 10 more just to SHOW you who is boss, and teach you for thinking about doing anything to it! ajw -----Original Message----- Sent: Thursday, May 30, 2002 7:48 AM To: Multiple recipients of list ORACLE-L Rachel, I agree with your short list of the areas of responsibilities but I would change the word "application" to "development". An application DBA, from the people I have talked to, is quite busy performing the upgrades and patches that accompany the Oracle Applications. The applications database generally has many, many tables, triggers and constraints and is constantly the target for upgrades and patches from Oracle. It is a time consuming task as the majority of the different applications (financial, HR, Purchase Order, etc) have "hooks" into each different package and are so intertwined that any small fix in one involves patches for the others. There are only a few user defined tables as each package has their own named tables that are partially shared between packages. There is very little if any work you can do on the application code because it is so intertwined and customized when it is installed. Any upgrades require that the "customization" be reworked to make it fit into the new version of the application package. It takes a longer time to install than a standard database, on the magnitude of days, and requires a dedicated and investigative mind set to maintain. To the list you created I would add: Help desk call recipient, network support, client support, software and hardware evaluation, "whipping" post, IT team member (possibly team leader), self driven, office coffee maker, consumer of various liquids. Ron ROR m���m >>> [EMAIL PROTECTED] 05/29/02 04:50PM >>> that's not a bad definition :) seriously, everyone will have their own definition, mine is: production dba -- responsible for all databases that are considered "production". this includes but is not limited to: backups recovery testing contingency testing production performance tuning (should mostly be database tuning as SQL really should be tuned at the development stage, with information passed back from the production DBA) documentation of all procedures space management on production systems, including capacity planning and projection of growth change management monitoring external data loads into production database health checks on production database application dba -- responsible for all databases in which developers have access. responsibilities: SQL tuning (not SQL coding!) database design, in conjunction with the developers any and all changes to the application schema working with the production DBA to ensure production performance (see SQL tuning!) backups (these might be weekly offline backups, as development is usually less critical but then again maybe not) as deadlines creep closer, the "weekends off" may not be this is just the "short" list I've usually been both the production and application dba where I've worked. Rachel --- Peter Barnett <[EMAIL PROTECTED]> wrote: > We are having this debate. What is a 'Production > DBA'? Right now all of the DBAs do some of > everything. In an effort to focus more DBA time on > infrastructure, damagement is floating the idea of > Production and Applications DBAs. The DBA group has > loosely translated this into the group that is always > on-call and the group that gets their weekends off. > > I would appreciate some input from those of you who > are Production DBAs. > > > > ===== > Pete Barnett > Lead Database Administrator > The Regence Group > [EMAIL PROTECTED] > > __________________________________________________ > Do You Yahoo!? > Yahoo! - Official partner of 2002 FIFA World Cup > http://fifaworldcup.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Peter Barnett > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mail ing 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! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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). begin 666 InterScan_Disclaimer.txt M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!I<R!S M=')I8W1L>2!C;VYF:61E;G1I86P@86YD(&9O<B!T:&4@:6YT96YD960@=7-E M(&]F('1H92!A9&1R97-S964@;VYL>3L@:70@;6%Y(&%L<V\@8F4@;&5G86QL M>2!P<FEV:6QE9V5D(&%N9"]O<B!P<FEC92!S96YS:71I=F4N("!.;W1I8V4@ M:7,@:&5R96)Y(&=I=F5N('1H870@86YY(&1I<V-L;W-U<F4L('5S92!O<B!C M;W!Y:6YG(&]F('1H92!I;F9O<FUA=&EO;B!B>2!A;GEO;F4@;W1H97(@=&AA M;B!T:&4@:6YT96YD960@<F5C:7!I96YT(&ES('!R;VAI8FET960@86YD(&UA M>2!B92!I;&QE9V%L+B @268@>6]U(&AA=F4@<F5C96EV960@=&AI<R!M97-S M86=E(&EN(&5R<F]R+"!P;&5A<V4@;F]T:69Y('1H92!S96YD97(@:6UM961I M871E;'D@8GD@<F5T=7)N(&4M;6%I;"X*"D-O<G!O<F%T92!3>7-T96US+"!) M;F,N(&AA<R!T86ME;B!E=F5R>2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@ M96YS=7)E('1H870@86YY(&%T=&%C:&UE;G0@=&\@=&AI<R!E+6UA:6P@:&%S M(&)E96X@<W=E<'0@9F]R('9I<G5S97,N("!792!A8V-E<'0@;F\@;&EA8FEL M:71Y(&9O<B!A;GD@9&%M86=E('-U<W1A:6YE9"!A<R!A(')E<W5L="!O9B!S M;V9T=V%R92!V:7)U<V5S(&%N9"!A9'9I<V4@>6]U(&-A<G)Y(&]U="!Y;W5R M(&]W;B!V:7)U<R!C:&5C:W,@8F5F;W)E(&]P96YI;F<@86YY(&%T=&%C:&UE %;G0N#0H end -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
