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.
What you'll learn
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.
Table of contents
- Managing Undo with Oracle 1m
- Understanding the ACID Test 7m
- Why You Need Undo 2m
- How Transactions Use Undo 4m
- Demo: Reviewing Your Undo Configuration 1m
- Errors Relating to Undo 2m
- Temporary Undo 3m
- Demo: Working with Undo Tablespaces 2m
- Redo vs. Undo 3m
- Understanding Undo Retention 4m
- Measuring Undo Generation 6m
- Guaranteeing Undo Retention 1m
- Querying Undo Data 8m
- Course Summary 2m
About the author
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