Oracle-L: RE: RE: Top 10 DBA Do's and Don'ts anyone

From: Ron Yount <ronwy_at_swbell.net>
Date: Tue, 25 Feb 2003 18:28:47 -0800
Message-ID: <F001.00559756.20030225182847@fatcity.com>

Been a while since I have been able to scan the list, but who could resist this one??? :-)

Additional Do's:

Do understand the nothing is unbreakable or bullet proof, assume the impossible isn't and have a plan for disaster management. Do appreciate that oracle support probably does deal with enough clueless people to expect you to be one of the same until you demonstrate otherwise. Do remember that somewhere there is life outside of RDBMS challenges, and it should be kept relative.
Do take the time to share your experiences, it makes life much simpler for all of us.
Do clearly define the objective, before you start detailing the solution.

Additional Do Nots
Don't get so focused on a prescribed solution that you don't realize when it becomes self-defeating to the driving cause. Don't forget that as good as you are at being a dba, you will make mistakes and mis-manage, and so will those who make a living managing you. Don't forget to prescribe the solution that user needs, not the one they necessarily demand.

And to the credit of Woodrow Wilson - "The wisest thing to do with a fool is to encourage him to hire a hall and discourse to his fellow citizens. Nothing chills nonsense like exposure to air."

-----Original Message-----
- IL
Sent: Monday, February 24, 2003 10:40 AM To: Multiple recipients of list ORACLE-L

SHOCK *

You mean someone disagrees with *ME*????

Horrors.... the world is soon to come to an end!!

:-))

Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com!

-----Original Message-----
Sent: Monday, February 24, 2003 7:09 AM
To: Multiple recipients of list ORACLE-L comments

MccDBA:

It is just Robert's Don't list ;) but you can always give your opinion abt that. Would you mind telling us 'Why you don't agree on them?'

dist cash <mccdba_at_hotmail.com> wrote:
>
>
> I don't agree with "don't" #1 and #5.
>
>
>
>
> >From: "Stephane Faroult" <sfaroult_at_oriolecorp.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my
> list,
> >comments
> >Date: Mon, 24 Feb 2003 00:23:37 -0800
> >
> > >Here is the list of top 10 do's and don't that I
> > >came up with.
> > >
> > >#1 - Do Maintain your Expertise
> > >#2 - Do Use the DBMS_STATS Package to Collect
> > >Statistics
> > >#3 - Do Use Bind Variables
> > >#4 - Do Put your Production Database in ARCHIVELOG
> > >Mode
> > >#5 - Do Use Locally Managed Tablespaces
> > >#6 - Do Monitor Your Database
> > >#7 - Do Practice Recoveries
> > >#8 - Do Get Involved with User Groups and Other
> > >Resources
> > >#9 - Do Establish Standards and Change Control
> > >Processes
> > >#10 - Do Think Ahead
> > >
> > >Bonus! - Do tune to Reduce Logical IO's Not
> > >Physical IO's.
> > >(With regards to Cary!)
> > >
> > >Oracle Database Top 10 Don'ts
> > >#1 - Don't Waste Time Re-Organizing Your Databases
> > >#2 - Don't Use .Log or Other Common Extensions For
> > >Your Database File Names
> > >#3 - Don't Leave Your Database Open To Attack
> > >#4 - Don't Decide Against Hot Backups
> > >#5 - Don't Use ASSM
> > >#6 - Don't Forget the 80/20 Rule
> > >#7 - Don't Stack Views
> > >#8 - Don't Be a Normalization Bigot
> > >#9 - Don't Forget to Document Everything
> > >#10 - Do Not Use Products You are Not Licensed For.
> > >
> > >
> > >Bonus!! - Do Not Assume A Good or Bad Hit Ratio
> > >Means Anything
> > >
> > >Ok, anyone wanna comment?
> > >
> > >
> > >Robert G. Freeman
> > >Technical Management Consultant
> > >TUSC - The Oracle Experts www.tusc.com
> > >904.708.5076 Cell (It's everywhere that I am!)
> > >Author of several books you can find on Amazon.com!
> > >
> >
> >Robert,
> >
> > DO #3 and DON'T #7 are developer stuff, not DBA stuff ... I would
> >gladly replace DO #3 by 'Relentlessly preach good practice
> to
> >developers'. I can hardly talk to a developer without mentioning
> >DBMA_APPLICATION_INFO in the first 30 seconds :-).
> >
> >Regards,
> >
> >Stephane Faroult
> >Oriole
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.net
> >--
> >Author: Stephane Faroult
> > INET: sfaroult_at_oriolecorp.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).
> >
>
>
> _________________________________________________________________
> The new MSN 8: advanced junk mail protection and 2 months FREE*
> http://join.msn.com/?page=features/junkmail
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: dist cash
> INET: mccdba_at_hotmail.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).
>

Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: K Gopalakrishnan
  INET: kaygopal_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: Freeman Robert - IL
  INET: FREEMANR_at_tusc.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: Ron Yount
  INET: ronwy_at_swbell.net

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 Tue Feb 25 2003 - 20:28:47 CST

RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm