C H A P T E R  16

Locking-Related Issues

In this chapter, we'll look at some issues related to locking in Oracle. In particular, we'll discuss the infamous “lost update” problem and various ways to address it. Along the way, we'll examine different strategies to implement two solutions to the lost update problem—namely, optimistic locking and pessimistic locking. We'll also compare these two solutions and determine when to use each strategy.