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