Defining Oracle good practices is a difficult process. The problem is that there are always exceptions for each good practice. Indeed, each practice needs its own "IF" and "WHEN" clauses (the versions of both the operating system and the Oracle software are also of vital importance). My goal here is to list the Oracle good practices that I have found to be applicable in most situations. They break down into six categories:
- Oracle environment
- Oracle backup, failover and disaster recovery
- Oracle system security
- Oracle design practices
- Oracle coding practices
- Oracle performance management and tuning
I am sure that if you study all of these good practices (and apply them) you will have better designed, maintained and performing Oracle databases.
About the author
Mike Ault is an Oracle database specialist at Quest Software and a recognized Oracle expert with over 16 years' experience as an Oracle DBA and consultant in a variety of industries and companies. A prolific author, Mike has published over 20 Oracle-related books including Oracle Administration and Management, Oracle DBA OCP ExamCram and Oracle10g Grid and RAC. He is a regular contributor to trade publications including Oracle magazine, and frequently presents at major Oracle conferences such as IOUG.