Overview

Introduction

The Managing Data Concurrency and Undo module explores the concepts of how to add, update and remove the data from tables, as well as how transactions work. It also introduces the concept of undo data and undo management. It also explores how Oracle manages locks to ensure data concurrency.

  • Monitor and Administer Undo
  • Configure Undo Retention
  • Monitor and resolve locking conflicts

Exercise 1 - Monitor and Administer UNDO

In this exercise you will learn the following about how to monitor and administer undo:

  • Establishing connection to the database
  • Achieving read consistency

Exercise 2 - Configure UNDO Retention

In this exercise, you will learn the following about how to configure undo retention:

  • Configuring the Undo Management

In the following section, you will learn to configure the undo tablespace using two initialization parameters: UNDO_MANAGEMENT and UNDO_TABLESPACE.

Exercise 3 - Monitor and Resolve Locking Conflicts

In this exercise, you will learn the following about how to monitor and resolve locking conflicts:

  • Maximizing the data concurrency
  • Using various LOCK modes

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.