DBA 该做的和不该做的

#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

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.

#11: DON'T attempt to use OID 9.0.1 on Linux with Replication because it

DON'T work reliably!

#12: DON'T use CURSOR_SHARING=FORCE in versions below 8.1.7.4 without

expecting problems.

#13: DON'T work against your Duhvelopers and SysAdmin Nazis. You're all

working to the same goal (or should be).

#14: DON'T expect MetaLink to have all the answers.

#15: DON'T allow any third party vendor that uses an Oracle DB to setup the

database. It will perform poorly, be all but completely unrecoverable, and

will not adhere to any of the standards you've put into place for your

company's protection and benefit.

#16: DON'T accept a vendor's requirement for unsupported versions of Oracle.

#17: DON'T be unyielding to compromise if it benefits your company (see

#13).