Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Managing Undo with Oracle

via Pluralsight

Overview

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.

Syllabus

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

Taught by

Agaba Philip

Reviews

Start your review of Managing Undo with Oracle

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.