Oracle Database Transactions and Locking Revealed: Building High Performance Through Concurrency

© Darl Kuhn and Thomas Kyte 2021

D. Kuhn, T. KyteOracle Database Transactions and Locking Revealedhttps://doi.org/10.1007/978-1-4842-6425-6_3

3. Locks, Latches, and Mutexes

Darl Kuhn¹  and Thomas Kyte²

(1)

Morrison, CO, USA

(2)

Denver, CO, USA

 

In this chapter, we’ll take a detailed look at how Oracle locks both data (e.g., rows in tables) and shared data structures (such as those found in the SGA). We’ll investigate the granularity to which Oracle locks data and what that means to you, the developer. When appropriate, I’ll contrast Oracle’s locking scheme with other popular implementations, mostly to dispel the myth that row-level locking adds overhead; in reality, it adds overhead only if the implementation adds overhead. In the next chapter, we’ll ...