December 2002
Intermediate to advanced
928 pages
85h 29m
English
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.