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:
The Database ACID Test
Multi Version Concurrency Control (MVCC)
Savepoints, commits, and rolling back transactions ...
Get Oracle Database 11g PL/SQL Programming Workbook 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.
