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

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!

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