DBA该做的和不该做的

发表于:2007-05-25来源:作者:点击数: 标签:该做不该MaintainYourexpert
> > #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 Monit

  >
  > #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 aclearcase/" target="_blank" >ccept a vendor's requirement for unsupported versions of Oracle.
  #17: DON'T be unyielding to compromise if it benefits your company (see
  #13).

原文转自:http://www.ltesting.net