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.
Author Name: Agaba Philip
Author Description:
I got my start in IT administrating an Oracle 10g database on Red Hat Linux. I’ve come a long way since and have used Linux everyday since 2012 both personally and professionally. As an independent consultant, I’m currently responsible for no less than forty Oracle databases running on Windows and Red Hat Servers. Perhaps the only thing I love almost as much as Linux is the Cloud and the many opportunities it provides. Linux has opened a lot of doors for me, and teaching it is my favorite pas… more

Table of Contents

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