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

I have to agree that it was the most entertaining Oracle presentation I have ever seen - and yet with lots of good stuff to take with you home from a guy who knows a lot about Oracle. Please re-consider your decision to move to Australia, Connor. Come back.

Connor McDonald wrote:

>"Connor does a much better job of presenting than I
>do."
>
>Translation: Connor waves his arms about, swears more
>and uses a little more BS, gives beer to attendees
>
>
> --- Freeman Robert - IL <FREEMANR_at_tusc.com> wrote: >
>
>
>>>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."
>>>>
>>>>
>>Interesting quote. It's funny, I do present with
>>some frequency, and I
>>stress out
>>about it every time I do.... I'm just sure that
>>there are folks out there
>>that know
>>a lot more about the topic I'm talking about than I
>>do. I fully expect,
>>every single
>>time, to hear hoards of folks laughing at me when I
>>say something totally
>>stupid.
>>
>>However, the best experience I have ever had
>>presenting was at UKOUG this
>>last year after my
>>Oracle9i New Features presentation. First, I got
>>some great feedback from
>>Jonathan Lewis,
>>which I was very thankful for (but, honestly, I was
>>so out of it at the time
>>(still in stress induced fight or flight mode) that
>>I don't remember much of
>>it!). Second, I saw a great presentation by Connor
>>McDonald on 9i. Connor
>>does a much better job of presenting than I do.
>>
>>
>>Cheers to you all!
>>
>>RF
>>
>>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: Tuesday, February 25, 2003 8:29 PM
>>To: Multiple recipients of list ORACLE-L
>>comm
>>
>>
>>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!!
>>
>>:-))
>>
>>RF
>>
>>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?'
>>
>>
>>KG
>>
>>--- 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).
>>--
>>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).
>>
>>
>>
>
>=====
>Connor McDonald
>web: http://www.oracledba.co.uk
>web: http://www.oaktable.net
>email: connor_mcdonald_at_yahoo.com
>
>"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"
>
>__________________________________________________
>Do You Yahoo!?
>Everything you'll ever need on one web page
>from News and Sport to Email and Music Charts
>http://uk.my.yahoo.com
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
  INET: mln_at_miracleas.dk

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).