Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 







Oracle Best Practices

Oracle Database Tips by Donald Burleson

Also see my notes on server room standards.

Following Oracle best practices is a critical management goal for many reasons:

Contrary to an Oracle "best practice", an Oracle Worst Practices are actions (or non-actions) that cause poor performance and create excessive management overhead, essentially a non-standard approach to Oracle database management.   

Areas of Oracle best practices

There are many areas of Oracle best practices, covering architecture best practices, DBA best practices and  Oracle developer best practices.

Oracle Best Practice:  Instance consolidation - There are many compelling benefits to having multiple instances on a large scalable server (Oracle instance consolidation), all part of the second age of mainframe computing:

Oracle Best Practice:  Proper change control - It is a best practice to fully test all production changes,, first in a TEST instance, and later in a QA instance, testing all possible scenarios before going into production.  One best practice to ensure optimal SQL execution in production is to provide an adequate database for your developers.  Remember, you can export your production schema statistics to make your development system look like production. 

Oracle Best Practice:  Enough testing instances - Many Oracle shops keep fours environments, DEV for development, TEST for unit testing, QA for pre-production testing, and PROD for production.  Any less Oracle testing and you may risk unintended side effects.

Oracle Best Practice:  Performance tracking - With STATSPACK (free) and AWR in Oracle10g, there is no excuse for not tracking your database performance.  STATSPACK and AWR provide a great historical performance record and set the foundation for DBA predictive modeling.  See my book Oracle Tuning: The Definitive Reference for details on Oracle monitoring best practices.

Oracle Best Practice:  Security management infrastructure- Oracle offers a host of access control mechanisms (grants, roles, VPD) yet it is amazing how many shops have giant security holes. See the book "Oracle Privacy Security Auditing" for Oracle security best practices.

Oracle Best Practice:  Standardized external environments - This is the worst of worst practices where every database uses different shells, different aliases and  non-standard file locations. 

Oracle best practice - audit changes to initialization parameters.  Tracking & auditing changes to your init.ora parameters


Rampant author Brian Peasland offers these Oracle best practices:

  • Maintain your database on current releases. Today that means you should be on either or If the former, you should already have a plan in place to get to before free extended support for expires early next year.  Too many DBAs let their version lag behind for a variety of reasons. They later find upgrades are more painful than if they had remained current. Plus they often end up engineering solutions that the new version provides as a new feature.

If you're on 12c, you could probably add lots of new features that can make your life easier.

  • Start using Unified Auditing.
  • Use IDENTITY columns or sequence NEXTVAL as default column values to populate that synthetic key column much faster than the old trigger selecting NEXTVAL.
  • In Memory columnstore.
  • Get the Diagnostics Pack and Tuning Pack for your environments. They are not cheap but they sure do make your life a lot easier. Many people who won't buy these because of the cost do not realize the they end up paying for themselves in about two years (your mileage may vary).
  • Learn how to create a testbed with Virtual Box on your workstation or laptop. There is no excuse any more for not having a testbed at your disposal. Even in many corporate environments with private cloud (or similar) implementations and Oracle VM or VMWare dominating in the enterprise, it may not be easy to standup an Oracle database just for a small proof-of-concept project. Too many times, it becomes political infighting within the IT department. But if you do this on your workstation, you'll be off and running and have total control of your testbed.
  • Get involved with social media. Follow blogs of Oracle experts, follow them on Twitter. Participate in the OTN and/or MOSC communities. There will be no better way to grow your career then when you are interacting with other Oracle professionals on a daily basis.
  • Learn another database system. When I started this career, it typically meant another RDBMS like SQL Server, DB2, etc. Now, it can also mean MongoDB, Hadoop, and others that are not relational in nature.  When learning these other systems, try to figure out how each is different an how each is the same. This will help solidify your overall database knowledge. For example, from a database theory perspective, we know that relational databases generate transaction logs. But how each does it differs.
  • If you're still using SQL*Plus daily, take a look at SQL Developer and how much of a timesaver it can be. And get a copy of SQLcl as well. SQL*Plus is still great and should still be in the DBAs arsenal though.

These are just a few of the top Oracle best practices.



Oracle Training at Sea
oracle dba poster

Follow us on Twitter 
Oracle performance tuning software 
Oracle Linux poster


Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2020

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.