This chapter discusses the intricacies of transaction control and scope. It also demonstrates how to create PL/SQL programs that intelligently handle large volumes of database interactions. Understanding transaction control is vital for developers and DBAs who want to create stable systems that ultimately protect enterprise information from data corruption or loss. We divide this chapter into the following topics:
The Database ACID Test
Multi Version Concurrency Control (MVCC)
Savepoints, commits, and rolling back transactions ...