What are Oracle worst practices?

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.


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:


For complete details, see my book "Oracle Tuning: The Definitive Reference":



Need Oracle Training?

The very best Oracle training comes from Burleson Consulting, where you get an on-site visit by an experienced Oracle expert and author.  Whether it's one-on-one mentoring or getting a customized on-site Oracle training class, there is no substitute for BC Oracle training.  Just call me at 800-766-1884 for details, and check-out our on-site Oracle training catalog: