Multi Version Concurrency Control

What is Multi Version Concurrency Control(MVCC)?

MVCC is a concurrency control algorithm which increase the concurrency & performance by generating a new version of a DB object each time the object is written.

The biggest advantage is that it does not use locking and hence there are no wait times & deadlocks.

It is used by most databases including all versions of Oracle.