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_4

4. Concurrency and Multiversioning

Darl Kuhn¹  and Thomas Kyte²

(1)

Morrison, CO, USA

(2)

Denver, CO, USA

 

As stated in the previous chapter, one of the key challenges in developing multiuser, database-driven applications is to maximize concurrent access but, at the same time, ensure that each user is able to read and modify the data in a consistent fashion. In this chapter, we’re going to take a detailed look at how Oracle achieves multiversion read consistency and what that means to you, the developer. I will also introduce a new term, write consistency, and use it to describe how Oracle works not only in a read ...