CHAPTER 7Concurrency and Multi-Versioning
As stated in the last 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 multi-version 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 environment with read consistency, but also in a mixed read and write environment.
What Are Concurrency Controls?
Concurrency controls are the collection of functions that the database provides to ...
Get Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions 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.
