CHAPTER 3Transaction Scope

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:

Image The Database ACID Test

Image Multi Version Concurrency Control (MVCC)

Savepoints, commits, and rolling back transactions ...

Get Oracle Database 11g PL/SQL Programming Workbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.