Managing Undo with Oracle

As an Oracle DBA, it’s compulsory that you have a solid understanding of the purpose and the mechanics of Undo.
This course teaches you the essentials of Undo data, and how to manage it.


Atomicity, Consistency, Isolation and Durability are the backbone of any relational structure. Knowledge of the ACID test is essential to understanding how the Oracle database guarantees transactional integrity. In this course, Managing Undo with Oracle, you will learn all you need to know about working with undo data in Oracle. In Oracle, Undo is the backbone of transactional integrity, you will start by understanding transactional integrity and the reason for Undo. First, you will explore the difference between Undo and Redo. Next, you will then move on to sizing the Undo tablespace to guarantee retention. Finally, you will learn to reverse errors by querying Undo data using Flashback. By the end of this course, you will have a solid understanding of Oracle Undo management. This knowledge will make you a more confident DBA.

• Course Overview 1min
• Managing Undo Data in Oracle 46mins