Oracle Database 10g: Managing Undo Data and Lock Conflicts Release 2
Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
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.
Course Number:
249302_eng