Oracle9i Database Fundamentals 1Z1-031: Managing Storage Structures and Undo Data

Products

Resources

Specials

Summary:

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

Objectives:

After completing this training course , students will be able to:

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

Outline:

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

Features:

Exercises that allow users to practice the application
A file containing the text of the exercises
Activities that allow users to apply training course concepts in an interactive questioning environment
A glossary
A Skill Assessment

Applicability:

This training course is for anyone preparing for the Oracle 1Z1-031: Oracle9i DBA Fundamentals I exam, or anyone who wants an introduction to Oracle database fundamentals.

Prerequisites:

Experience working with relational database systemstraining course s on SQL or equivalent experienceGeneral knowledge of networkingOracle9i Database Fundamentals 1Z1-031: Oracle Architecture and ToolsOracle9i Database Fundamentals 1Z1-031:Managing Instances and Creating DatabasesOracle9i Database Fundamentals 1Z1-031: Managing the Database StructureOracle9i Database Fundamentals 1Z1-031: Managing Tablespaces and Datafiles

Technical Requirements:

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 95, 98, NT, 2000, or XP. Minimum Connection Speed: 28.8k. Internet Explorer 5.0 or higher required. Authorware and Macromedia Flash player recommended but not required. JavaScript must be enabled. Netscape and AOL browsers not supported.

Copyright Information:

Oracle® and Oracle9i™ are trademarks of Oracle Corporation.

Terms of Use:

None