Chapter 3. Concurrency

One of the most important features of a database is the way that it supports multiple users. The Oracle database has a concurrency scheme to support concurrent access by multiple users called multiversion read consistency (MVRC) that is unique among major databases. This feature is a great benefit to application developers, because it removes the need for them to worry about handling most locking issues in their own code. The ability to support MVRC is built deeply into the architecture of the Oracle database.

This chapter summarizes the concepts involved in implementing a concurrency scheme and describes briefly how Oracle’s MVRC features work.

Get Oracle in a Nutshell 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.