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

Hi,

#8 - Don't Be a Normalization Bigot

I would have written the above as "Don't denormalise without good reason."

To me denormalisation means that you must have a normalised design to begin with, in order to "de-normalise" it.

I've seen a lot of designs where the designers have denormalised a set of tables to improve a perceived performance problem in one part of an application only to find out later that it adversely effected the performance of another part. The designers didn't even understand what the normalised design should be! I tend to find that starting with a normalised design is much more robust way to go.

Cheers,
Craig.

-----Original Message-----
Sent: Monday, 24 February 2003 9:24 AM
To: Multiple recipients of list ORACLE-L 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Craig Munday
  INET: Craig.Munday_at_ecard.com.au

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