Oracle Database Transactions and Locking Revealed

Introduction

I’ve been asked many times, “What is the key to building highly concurrent and scalable database applications?” Invariably my response is “Begin with the basics, start with thoroughly understanding how Oracle manages transactions.”

When designing and creating database applications, understanding how the underlying database manages transactions will enable you to make intelligent architectural decisions that result in highly concurrent and scalable applications. Without knowledge of how the database handles transactions, you’ll invariably make poor design choices and end up with code that will never perform well. If you’re going to be building systems that use an Oracle database, it’s critical that you understand Oracle’s transaction ...