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

Connor corollary to Wilson theory...
"The truth will out...especially when demonstrated with free beer!"

Freeman Robert - IL 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: Daniel W. Fink
  INET: optimaldba_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).