Everyone who is an Oracle expert was a beginner once, and many people seem to make the same mistakes as they are learning. This is a collection of posts about things commonly done wrong so you don't have to learn things the hard way.

With Oracle there is often more than one way to do something, and more often than not, one way is better than another, so how do you know which approach is best? By benchmarking of course, and this series of articles will introduce you to the tools that allow you to do just that.

In a series of 3 articles, I explore check constraints, unique indexes and foreign keys including a detailed analysis of their performance, hopefully dispelling some of the myths surrounding Referential Integrity.

A series of articles exploring how to unit test PLSQL code using Ruby and JDBC.

Oracle 11gR2 introduced the ability to make changes to tables and running PLSQL without impacting the live application in any way. This series of articles walks through using these new features.