DBA 该做的和不该做的
2024-07-21 02:35:42
供稿：网友
>
> #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).
