Oracle Database 10g: Managing Undo Data and Lock Conflicts

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
110 Minutes

Objectives:

Oracle Database 10g: Managing Undo Data and Lock Conflicts

  • 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.


    • Course Number: 221535_eng