Oracle Database 10g: Managing Undo Data and Lock Conflicts Release 2

Overview/Description
To discuss how to manage undo data and manage lock conflicts in an Oracle database

Target Audience
Anyone wanting to learn about Oracle Database 10g database administration

Prerequisites
An understanding of database concepts and technologies

Expected Duration (hours)
1.8

Lesson Objectives

Oracle Database 10g: Managing Undo Data and Lock Conflicts Release 2

identify factors to take into consideration when managing undo.

recognize how to estimate required tablespace size and resize a tablespace in a given scenario.

calculate undo tablespace sizing and resize an undo tablespace.

recognize how locks are used to ensure concurrent user access to a database.

manage lock conflicts.

detect and resolve lock conflicts.