© Darl Kuhn and Thomas Kyte 2021
D. Kuhn, T. KyteOracle Database Transactions and Locking Revealedhttps://doi.org/10.1007/978-1-4842-6425-6_6

6. Redo and Undo

Darl Kuhn1  and Thomas Kyte2
(1)
Morrison, CO, USA
(2)
Denver, CO, USA
 

This chapter introduces you to two of the most important pieces of data in an Oracle database: redo and undo. Redo is the information Oracle records in online (and archived) redo log files in order to “replay” your transaction in the event of a failure. Undo is the information Oracle records in the undo segments in order to reverse, or roll back, your transaction.

In this chapter, we will discuss topics such as how redo and undo (rollback) are generated, and how they fit into transactions. We’ll also discuss the performance ...

Get Oracle Database Transactions and Locking Revealed: Building High Performance Through Concurrency 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.