MP9003: Network and Database (General) - Managing Storage Structures and Undo Data > Oracle9i Database Fundamentals 1Z0-031

This course introduces users to the underlying storage structure of a database and to using undo segments. 

Topics:
Types of segments
Acquiring and managing segments and extents
Controlling block space usage
Obtaining information about storage structures
Using undo data
Implementing automatic undo Management
Creating, configuring, and maintaining undo Segments manually

Objectives:
Identify storage needs for different segment types
Control the size allocation of extents and segments
Acquire extents in dictionary-managed tablespaces
Use multiple extents when using parallel processors
List the keywords that control block space usage
Obtain information about storage from the data dictionary
Describe the purpose of undo data
Implement automatic undo management
Create and configure undo segments
Size OLTP and batch undo segments
Maintain undo segments manually

Duration:
4 Hours