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
See the full benefits of our immersive learning experience with interactive courses and guided career paths.