There is a great deal of discussion about following Oracle best practices (e.g. using OFA, etc.) but little has been said about Oracle worst practices. Contrary to an Oracle "best practice", an Oracle "worst practice" are actions (or non-actions) that cause poor performance and create excessive management overhead, essentially a non-standard approach to Oracle database management. Let's look at a few of my Oracle worst practices:
Many Oracle shops commission an Oracle Health Check to find these issues, but worst practices are alive-and-well in the Oracle community.
http://www.dba-oracle.com/oracle_health_check.htm
I describe Oracle worst practices into several general areas:
- PL/SQL worst practices
- Oracle DBA worst practices
- Oracle design worst practices
- Oracle architecture worst practices
Read my complete treatise on Oracle worst practices here:
http://www.dba-oracle.com/t_worst_practices.htm
For complete details, see my book "Oracle Tuning: The Definitive Reference":
http://www.rampant-books.com/book_2005_1_awr_proactive_tuning.htm
What are Oracle worst practices?
