Better At Oracle

A collection of tutorials, code and tools to help you get better using Oracle

July 14, 2011

The most common things done wrong

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.

June 23, 2011

The Oracle Developers Benchmarking Toolkit

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.

July 13, 2011

All About Referential Integrity

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.

March 04, 2013

Unit Testing PLSQL with Ruby

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

May 26, 2011

Online Application Upgrades using Edition Based Redefinition

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.