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.
Locking in Oracle
A lock is a mechanism Oracle uses to prevent destructive interaction between transactions accessing the same resource. Here, the resource could be user objects, such as tables; or user ...
Get Expert Oracle JDBC Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
