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

Wow, this statement...

>>> If you are a Decision Support database, then ARCHIVELOG is not needed.

is one very broad and daring statement.

>>> tday6_at_csc.com 02/24/03 09:03AM >>>

#4 on the Do list assumes that you are an On-Line Transaction Process
database. If you are a Decision Support database, then ARCHIVELOG is not needed. But, as a general rule, the world would be a better place if more production DBAs had their databases in ARCHIVELOG mode. #4 on the DO list is the same as #4 on the DON'T list (or have they got a way now to do hot backups without ARCHIVELOG mode?)

My #1 don't is never, ever delete an OS file. Rename it, wait a week, and if everything is still running OK then delete the renamed file.

                                                                                                                                       
                      Freeman Robert -                                                                                                 
                      IL <FREEMANR             To:      Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>                    
                      @tusc.com>               cc:                                                                                     
                      Sent by: root            Subject: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments              
                                                                                                                                       
                                                                                                                                       
                      02/23/2003 05:23                                                                                                 
                      PM                                                                                                               
                      Please respond                                                                                                   
                      to ORACLE-L                                                                                                      
                                                                                                                                       
                                                                                                                                       

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: Thomas Day
  INET: tday6_at_csc.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: Darrell Landrum
  INET: DLANDRUM_at_zalecorp.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).